How To Convert Row Into Column Column Into Row In Excel Transpose (rotate) data from rows to columns or vice versa. Highlight the area you want to transpose and then press ctrl c on the keyboard to copy the data. right click the empty cell where you'd like to display your results. under "paste options" click "paste special." check the box next to "transpose" and then press the "ok" button.
How To Convert Multiple Rows To Columns And Rows In Excel Or, select the row and press ctrl c. 4. activate the destination cell (where you want the column to appear). 5. right click again to launch the context menu, as shown below. 6. click on the option paste special under paste options. 7. from the ‘paste special’ dialogue box, click ‘transpose’ and click ‘okay’. Method 3 – applying the transpose function. steps: go to cell b11 and enter the following formula into the formula bar: =transpose(b4:i9) formula breakdown. the column and row functions return the column and row number for these cell references. as example, column (b4) returns 2, row (b4) returns 4. Select the data you want to transpose. go to the home tab. click on the copy command. you can also select the data then use the ctrl c keyboard shortcut to copy the data instead of using the ribbon commands. paste the data using the transpose command. select the cell where you want the transposed data. How to convert a row to a column in excel the easy way.
Comments are closed.