Move a Column to rows
 

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


--
soddydj
------------------------------------------------------------------------
soddydj's Profile: http://www.excelforum.com/member.php...o&userid=25714
View this thread: http://www.excelforum.com/showthread...hreadid=391296

Try using Copy then Paste Special - Transpose

HTH

Phil

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.


--
swedish max
------------------------------------------------------------------------
swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408
View this thread: http://www.excelforum.com/showthread...hreadid=391296