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.

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…