Here are the steps to convert columns to rows in Excel:
1. Open the spreadsheet you need to change.
2. Click the first cell in your cell range such as A1.
3. Shift-click the last cell of the range. Your data set should highlight.
4. From the Home tab, select Copy or type Ctrl + c.
5. Select a cell where you want to paste your transposed data.
6. Right-click and select Transpose from the Paste Options menu.
You can also use the Paste Special command to transpose columns to rows in Excel:
1. Open the spreadsheet you need to change.
2. Click the first cell in your cell range such as A1.
3. Shift-click the last cell of the range. Your data set should highlight.
4. From the Home tab, select Copy or type Ctrl + c.
5. Select a cell where you want to paste your transposed data.
6. Right-click and select Paste Special from the Paste Options menu.
7. In the Paste Special dialog box, check Transpose and click OK.
I hope this helps! Let me know if you have any other questions or if there's anything else I can help you with.
[Here](https://www.timeatlas.com/switch-excel-columns-rows/) is a link to a tutorial that explains how to convert columns to rows in Excel using both methods above step by step with screenshots.
