I'm working with the transpose function, and I'm not sure it's what I
really need. I have a column of data like:

A1 1
A2 2
A3 3
A4 4
A5 5
A6 6
A7 7
A8 8
A9 9
A10 10
A11 11
A12 12

Without manually coding, I need the information to transpose into:

a b c d e f
1 1 2 3 4 5 6
2 7 8 9 10 11 12

Any suggestions?

Thanks.


--
rollinn95z
------------------------------------------------------------------------
rollinn95z's Profile: http://www.excelforum.com/member.php...o&userid=33571
View this thread: http://www.excelforum.com/showthread...hreadid=545162