Question: how to copy a column in excel to a row?
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.