Excel Help - How to Switch Columns and Rows in Excel 2013
This video will show you how rearrange your data from rows to columns and vice versa. In Excel, switching rows and columns is called “transposing”. If you entered your data in rows and want to move it to columns instead for better display or vice versa, you can do this quickly and easily with the “transpose” function.
This video starts by rearranging data from rows to columns.
To do this, select the cells in the rows that contain the data.
Right click and click Copy.
Now choose the location of the new columns and select the first cell in the destination columns.
Right-click and click Paste Special.
Select the Transpose checkbox.
Click OK.
The steps are the same for moving data from columns to rows.
Select the column.
Right click and click Copy.
Now choose the location of the new columns and select the first cell in the destination columns.
Right-click and click Paste Special.
Select the Transpose checkbox.
Click OK.
