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.