text data in one column many rows to many columns one row
 

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: http://www.excelforum.com/member.php...o&userid=32436
View this thread: http://www.excelforum.com/showthread...hreadid=522089

text data in one column many rows to many columns one row
 

"MoniqueL" wrote in
message ...

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

Copy/ Paste Special/ Transpose
--
David Biddulph