How to Convert a Row to a Column in Excel. In this article, you will read an easy way to convert row into column in Microsoft Excel. Sometimes, we enter the data in a column in Excel. But, later we feel that it would be better if this data was in a row. You think how you can reverse the rows into columns, because you do no want to re-enter the data.
To solve this issue, just use the Excel’s Transpose feature.
How to Convert a Row to a Column in Excel?
To convert rows into columns in Excel:
1.Select the cells containing the headings and data you want to transpose.
2.Click the “Copy” button or press Ctrl+C to copy the selected cells.
3.Click a blank cell where you want to copy the transposed data.
4.The selected cell will bet at the top left corner of whatever you’re copying.
5.Click the down arrow under the “Paste” button.
6.Then, click the “Transpose” button on the dropdown menu.
7.Now, your rows become columns and your columns become rows.
8.The original, pre-transposed data still exists.
9.If you want to delete them, then select those files.