Quick summary
Converting columns to rows in Microsoft Excel is done using the built-in Transpose paste option, which rotates your data without manual re-entry. This method works by copying your column data and pasting it with the Transpose icon found under Paste Options.
Steps
- Highlight the column(s) you want to convert to rows.
- Right-click and select Copy, or press Ctrl + C to copy the selected data.
- Click on the destination cell where you want the row data, right-click, and under Paste Options select the Transpose icon (a clipboard with a rotating arrow).
- Your column data will now be successfully converted to rows.
