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.24nl0a_1142328902.3053@excelforum-nospam.com> wrote in
message news:MoniqueL.24nl0a_1142328902.3053@excelforum-nospam.com...
>
> 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