Hi

For a one off task on a small set of data as shown, then
Mark A1:A6Copymove to cell B1Paste SpecialTranspose
Mark A7:A12Copymove to cell B2Paste SpecialTranspose
Delete column A

For a formula solution dealing with a larger set of data, enter the
following in cell B1
=OFFSET($A1,COLUMN()-2+(ROW()-1)*5,0)
copy across through cells C1:G1
copy B1:G1 down through cells B2 for as many rows as you wish (or until
you see a row of zero's appearing)
To "fix" the transformation, copy B1:Gxxx where xxx is the row number
you have gone down to.
Move cursor to cell B1paste SpecialValues
Delete column A

--
Regards

Roger Govier


"rollinn95z"
wrote in message
...

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