You may use the TRANSPOSE function, inserting it in all the cells as the same
array formula.
To do so, select the range A1:F1, write the formula
=TRANSPOSE(Sheet1!A1:A6)
And enter it with CRTL+SHIFT+ENTER. On the A2:F2 the formula should be
=TRANSPOSE(Sheet1!A7:A12)
I have used Sheet1 here as the ranges are overlaping.
In order to get all the different results, all the cells must be highlighted
when entering the array formula.

Hope this helps,
Miguel.

"rollinn95z" wrote:


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