Hi all,

I am going bananas trying to manully transpose my data....surely there is a way to macro it?!?

My data looks like this:

A 123
A 456
A 789
B 987
B 654
C 321
C 147
C 369
D 564

and it needs to get to....

A 123 456 789
B 987 654
C 321 147 369
D 564

I will kiss the feet of anyone who can help me!!!
I have over 3000 lines to do EEK!