Excel

Resolved · Low Priority · Version 2007

Thu 19 Dec 2013, 09:11 Delegate Beverley said...

Beverley has attended:
Multiple applications course
Multiple applications course

Excel

Can you change a row full of data into a columnar format

Thu 19 Dec 2013, 14:09 Trainer Marius said...

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

Thu 19 Dec 2013, 14:41 Delegate Beverley said...

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

Thu 19 Dec 2013, 14:42 Delegate Beverley said...

RE: Excel

Marius - I am using excel 2010. Regards

Beverley

Thu 19 Dec 2013, 16:06 Trainer Marius said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Using the Windows Keyboard key

The Windows Key,(WK) typically found at the bottom left hand corner, can be found on most keyboards, and has a number of different uses:

To open the Start menu: WK
To minimise all windows WK+ D
To open all windows again WK+ shift + M
To open Windows Explorer WK + E
To move across the Task Bar WK + tab
To open the Search window WK + F
To open the Run dialogue box WK + R
To open the System Properties dialogue box WK + break

You may be able to perform other actions with the windows key depending on which programs you have installed on your PC.

View all Microsoft Office hints and tips