Paste the cells in an unused part of the Excel sheet.
Select the cells in the column you have just pasted.
Copy them, select the first destination cell,
right-click, checkmark in 'Transpose' click OK.

George Gee

One way, assuming the col data is in regular groups of x lines per
group ..

Assuming source data in A1 down, with data in 10 lines per group viz:
1st group in A1:A10, 2nd group in A11:A20, 3rd group in A21:A30 etc

Put in B1:
=INDEX($A:$A,ROW(A1)*10-10+COLUMN(A1))
Copy B1 across by 10 cols to K1, then fill down until zeros appear,
signalling exhaustion of data. Cols B to K will return the required
results.

Adapt to suit the x lines per group, viz. change the "10" in the
formula to x, then copy across by x cols, fill down ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---