Hi,

I am having data in two columns as below

column1 column2
top level sub level
a a1
a a2
a a3
a a4
b b1
b b2
b b3
b b4
b b5

now i need the data to get represented column wise as below. Since the data is huge VBA code would be appropriate.

column1 column2 column3 column4 column5 coumn6
Top level Sub level Sub level Sub level Sub level Sub level
a a1 a2 a3 a4
b b1 b2 b3 b4 b5


regards
Sreejesh