Does transpose work on a table?
The above example was a simple one. We took a row and turned it into a column (and vice versa).
But what comes now is not only a row of weekdays but a whole timetable.
The above image shows different weekdays and time slots. For each time slot and each weekday, classes for different subjects are scheduled.
Presently, time slots are arranged in a horizontal range (in a row). And weekdays are in a vertical range (in a column).
To turn the table the other way around, follow these steps.
1. Select the table.
2. Right-click anywhere on the table to launch the context menu and select Copy.
3. Activate the destination range (where you want the transposed cells to appear).
4. Right-click again to launch the context menu
6. Click on the Option Paste Special.
7. From the ‘Paste Special’ dialogue box, click ‘ Transpose’ and click ‘Okay’
The table takes a whole new look.
And here we have the transposed table.
Pay attention to see how the time slots are now organized in a vertical range. Similarly, weekdays take the shape of a row.
The data in between is also transposed accordingly.
Easy enough, isn’t it?