Moving the data from a column to a row in excel is quite easy to do. Just follow these steps.
1. Select all the column or group of cells in a column that you want to move to a row
2. Cut the cells using Control + x
3. Right click on the row where you want to paste the data - OR - select a cell and use the paste button on the top ribbon
4. From the fly out menu under the "paste" options, click the "transpose" icon.
Want to learn more? Check out our excel training courses.
Comments