Columns to rows

S

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
 
R

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
 
Top