Beverley has attended:
Multiple applications course
Multiple applications course
Excel
Can you change a row full of data into a columnar format
RE: Excel
Good day Beverley,
Thank you for your question. I have good news. It is quite easy to change the layout of your data from appearing in a row to appearing in a column. You simply select the data, copy it, then right-click in the cell of the column where you want to paste it. In the options box which appears, select "Paste Special". Then tick the box next to "Transpose" (bottom right). When you click OK, your data will be pasted vertically in a columnar layout.
Likewise, you can "transpose" data from a column to a row layout.
I hope this answers your question.
Kind regards
Marius Barnard
Excel Trainer
Best STL
RE: Excel
Hi Marius -
Thank you for your reply.
When I right click three icons come up under paste options and they are
Paste
Paste Link
Match destination formatting
There are no other options.
Regards
Beverley
RE: Excel
Marius - I am using excel 2010. Regards
Beverley
RE: Excel
Hi Beverley,
In 2010, when you right-click to paste the data, the fourth button under "Paste Options" in the options box is the "Transpose" button.
Alternatively, if you click the bottom half of the Paste button in the Home ribbon (Clipboard group), you will find the "Paste Special" option. Click on that and you'll find the "Transpose" option again.
Hope this helps!
Regards
Marius
