Excel’s “Transpose” feature lets you turn rows into columns and vice versa; see how to use it via PC and mobile
Need to turn a row into a column in an Excel spreadsheet? The “Transpose” feature lets you do this conversion quickly, without the need to copy and paste every single cell.
There are two ways to use the resource in Excel: by selecting the cell with the mouse or with a formula in the software. Before running the command, make sure you have enough space on your worksheet to enter the data as a new row or column.
The process is also used to reverse the path and turn columns into rows.
How to convert row to column in Excel
The feature is available in the browser, macOS, and Windows versions of Excel.
- Open a spreadsheet;
- Select the row or column you want to convert;
- Press Ctrl + C to copy it;
- Select another cell to enter data;
- Right click;
- In the paste options, select “Transpose”;
- View modified cells in column format.
How to use the “Transpose” formula in Excel
- Click on an empty cell;
- Type = TRANSPOSED;
- Then select the range of cells you want to convert;
- Press Enter.
How to use the “Transpose” function on mobile
In the Microsoft 365 App (android | iOS), you can only use the resource from the formula:
- Open a spreadsheet in Microsoft 365;
- Touch a cell to open the text box;
- Type =TRANSPOSE and choose the displayed function;
- Tap and drag across the range of cells you want to transform;
- Press the check icon.
If the data is in another worksheet, it is necessary connect cells in another document and then use the “Transpose” function.
Trending on Canaltech:
- Does China’s Giant Hydroelectric Dam Affect Earth’s Rotation?
- Better a 1.0 turbo or a 2.0 naturally aspirated?
- Superman is shocked to learn who protected Metropolis before him.
- Is it still worth buying the Redmi Note 11 Pro Plus 5G?
- 10 most viewed series of the week (05/21/2023)
- WHO stops recommending sweeteners for weight control diets
Source: Terra
Rose James is a Gossipify movie and series reviewer known for her in-depth analysis and unique perspective on the latest releases. With a background in film studies, she provides engaging and informative reviews, and keeps readers up to date with industry trends and emerging talents.
