Columns to rows

[Samantha]

I have data in a column and I want to change it to Rows
without cutting an pasting each bit can you help?

Thanks

 

[Ron de Bruin]

Hi Samantha

Select A1:A10 and copy
Right click on cell B1 or so and choose PasteSpecial
Check Transpose
OK

Remember that you have only 256 columns