You may have observed that you can copy or move cells, rows, columns, or ranges in Microsoft Office Excel at your convenience. However, there appears to be no trick available for swapping them. Not anymore! If you are unaware of it, Excel supports a one-click operation to swap rows, columns, or ranges quickly, known as Transpose.
Transpose Row to Column in Excel
Convert Rows to Columns with Transpose in Excel
Tne transpose option allows you to convert rows into column and vice versa.
- From your Excel sheet, select the cells you want to change.
- Once done, Right-Click and select the Copy option.
- Next, right-click on an empty cell and choose Paste Options > Transpose, as shown in the screenshot below.
One of the highlights of Excel is that it will show you a preview of what the paste would look like before confirming the action.
- If you do not see it, alternatively Right-Click an empty cell and select Paste Special.
- Then, from its window, you can check the Transpose box and click OK.
- You will now see your data transposed to a new layout style.
The same feature allows you to convert horizontal row data sheets into vertical column style sheets.
The feature works with all recent versions of Microsoft Excel, including Office 365.
I hope the post was easy to follow and you can now transpose rows into columns.
How do you transpose a cell to a zero in Excel?
If you need to convert all blank cells to zeros, use the Transpose feature. It comes in handy when you have too many blanks in a row or column that would take a lot of time to fill. Instead, using transpose automatically fills blanks to zeros.
Read: How to split one single long column into multiple columns in Excel
How do you transpose text in Microsoft Office?
If you want to convert horizontal text to vertical text, select the text and click on the Alignment section under the Home Tab. Select the Vertical option text, which will transpose within the same cell.
How do I change the order of columns in an Excel spreadsheet?
If you need to move a column to the left, correct, or anywhere in the Excel file, it’s simple. First, you need to select the column by clicking on its header. Then press the Shift key and hover the mouse pointer to one of the sides. You can then drag and move it anywhere, ensuring you do not release the Shift key.