Copy the data
Select the target area
EditPastespecial and click Transpose.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"asianmike" wrote
in message ...
Is there a way to convert rows to columns?
a b c d ...
aa bb cc dd ...
to
a aa
b bb
c cc
d dd
..
--
asianmike
------------------------------------------------------------------------
asianmike's Profile:
http://www.excelforum.com/member.php...o&userid=30973
View this thread: http://www.excelforum.com/showthread...hreadid=507661