How to copy the data in row to column?

[Suma Charan]

I want the data I entered in rows in a worksheet into columns in the same
worksheet.

 

[Niek Otten]

Copy, Paste Special, ckeck Transpose

--
Kind regards,

Niek Otten

Microsoft MVP - Excel