Swapping Rows and Columns in Excel Quickly
Key points
- Copy the range
- Paste it
- Paste back to Excel
With Table Transpose you can swap rows and columns without hunting for paste settings.
Steps
- Copy the range
- Paste it
- Paste back to Excel
The resulting table is copied as tab-separated text.
Use "Swap Rows and Columns of a Table" (free)
Tools that go well with this
- Excel Table to Markdown, HTML, CSV and JSON: Convert a pasted table to Markdown, HTML, CSV or JSON.
- Merge, Split and Pick Columns from CSV: Merge CSV files, split by rows, or keep only chosen columns.
- Convert Excel to CSV or JSON: Convert an Excel sheet to CSV, TSV or JSON.