may i know is it possible to do the grouping as following in excel? Pivopt is one kind of that, but pivoting is grouping and counting into number...
what i wnat is just as below:
Thanks


Raw:
ColumnA ColumnB
City A
City B
Country US
Country Britain
City C
City D
Country Argentina


Result:

City
A
B
C
D

Country
US
Britain
Argentina