Question: how to move data from columns to rows?
Answer: Open the spreadsheet you need to change. ...  Click the first cell of your data range such as A1. Shift-click the last cell of the range. ...  From the Home tab, select Copy or type Ctrl + c . Select the new cell where you would like to copy your transposed data.