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