December 3, 2020

How to Convert Row to Column and vice versa in Excel

To convert the rows of a table into columns and the columns to rows in excel use Transpose functionality available in Excel.

Step 1 : In the below example we have created a table consisting of 3 rows and 4 columns.

Step 2 : Now select the cell (Here A7) to transpose the table. Click on the ‘Transpose’ Icon in Home tab as shown in the first image below. In lower version of excel you can find the ‘Transpose’ menu by clicking on the down arrow in ‘Paste’ symbol of Home tab.

               

Step 3 : Here is the Transposed form of the table where rows have been converted to columns and vice versa.

Leave a Reply

Your email address will not be published. Required fields are marked *