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


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:

Add a comment »One comment to this article

  1. Can you help me with rotate (NOT transpose) a table 90 degrees clockwise? I think it is a different problem than here in this example. I have Excel but I am not good at VBA or macros.


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