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.