software

I have several worksheets with a single column of text data (about 20
rows) - I would like to rotate this data so that it now appears across
the columns and in one row (and not down the column and in several
rows) - how do I do this?
I would like to delete the original sheets afterwards.
thanks--
MoniqueL
------------------------------------------------------------------------
MoniqueL's Profile: www.excelforum.com/member.php...oamp;userid=32436
View this thread: www.excelforum.com/showthread...hreadid=522089quot;MoniqueLquot; gt; wrote in
message ...
gt;
gt; I have several worksheets with a single column of text data (about 20
gt; rows) - I would like to rotate this data so that it now appears across
gt; the columns and in one row (and not down the column and in several
gt; rows) - how do I do this?
gt; I would like to delete the original sheets afterwards.
gt; thanks

Copy/ Paste Special/ Transpose
--
David Biddulph