Joachim P. asks:
I have received an Excel spreadsheet. The addresses are next to each other. If I want to enter a new address, I have to scroll far to the right. The structure is extremely impractical. I don’t understand how you can create such a cumbersome list. I would therefore like to rotate the rows and columns in Excel so that the addresses are below each other instead of next to each other in the rows. Is that possible?
How to swap rows and columns in an Excel spreadsheet in no time at all
If your Excel table has addresses running across rows instead of down columns, the Excel Transpose command is the fix you need — no re-entering data required. In just a few steps, you can swap rows and columns instantly: copy the original table, select a free area, and paste using the Transpose option to reverse the entire structure. The result is a far more practical layout that's easier to scroll, filter, sort, and extend with new entries. Deleting the old table afterwards takes only seconds, leaving you with a clean, optimised table structure that works the way a proper address list should. Read on for the complete step-by-step guide to transposing your data in Excel.
4 Min. reading time
15 April 2026
