Copy, Paste Special, ckeck Transpose

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Suma Charan" <Suma wrote in message
...
I want the data I entered in rows in a worksheet into columns in the same
worksheet.