How to convert rows into columns in Excel
By
SpreadCheaters
Microsoft Excel is an electronic spreadsheet with numerous rows and columns, used for organizing data. In most of the cases, we face a condition in which rows need to be converted into columns. In this scenario Excel facilitates us with its built-in tools and functions.
To do the needful, let’s start with following steps;
Step 1 – Select the rows and columns
– Select the rows and columns from the data range.
– Copy the selected data range by pressing hotkey CTRL + C or right click on the selected area, click copy.
Above is an example.
Step 2 – Select another cell to convert
– Select a separate cell in which you wish to convert rows in columns
– In this case, our selected cell is H8.
– Click on the Paste option .
– A drop down menu will appear.
– Click on TRANSPOSE.
– As you press the enter key. Rows will be converted into columns.
Above is an animation as an example.
