How to Convert Columns to Rows in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Highlight the column(s) you want to convert to rows.
2. Right-click and select Copy, or press Ctrl + C.
3. Click on the cell where you want to paste the data as rows, right-click, and under Paste Options, select the Transpose icon (a clipboard with a rotating arrow).
4. Your column data will now be converted to rows!