Move a Column to rows

[soddydj]

How can I move text that is in a column to rows.

[swedish max]

Copy the cells in the column you want to be in a row, go to the cell you want to paste the data and hit Edit, Paste Special and select Transpose in the tickbox. Click ok.

[Phil]

Try using Copy then Paste Special - Transpose

HTH

Phil