How to rotate and transpose a table

The table in this example should be rotated in such a way that we change rows per columns. We will use Transpose from the Excel menu to solve it.

Table to rotate

Solution

The table does not rotate directly, it will be copied and then rotated. So select the table and choose copy (or CTRL+C). Then right-click to the place you want to insert rotated table and select Paste Special…

Paste Special

In Paste Special menu check Transpose.

Transpose menu

And that’s all. Table is transposed.

 

Transposed table

See this on video tutorial:



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress