How to pivot Excel table rows into columns?
This short Excel tutorial is about to pivot Excel data from Rows to Columns ?
Let's do this with 3 very simple steps.
In fact, here are the details of the three steps to transpose the rows of the Excel table into columns.
1 - First of all, select the whole area to be pivoted in the Excel worksheet. With the mouse or the arrows if it is a large area. Or simpler, with the shortcut CTRL+A for a table with contigus data.
2 - Then copy the table to pivot with CTRL+C or do a right-click and COPY.
3 - Then right-click, select PASTE SPECIAL, then TRANSPOSE, as shown in the video.
Let us some feedback about this short very useful tip!
Cheers!
A written blog post is available here: https://expert-only.com/en/excel-tips...