Transpose Data from Rows to Columns or Columns to Rows
If you have a worksheet with data in columns that you want to rotate (transpose) into rows, you can simply use the Transpose feature under paste special.
For example, we have sales by region data and we would like to rotate, so we can see months on the rows and regions on the columns.
Follow below steps to transpose the data:
1. Select the table and copy
2. Click on the cell where you would like to transpose
3. Right click and select transpose option under Paste options/Paste Special options
4. Now, you will see data get transposed easily.
You can easily transpose data using the above steps from columns to rows and rows to columns.
