Because we all have our worksheet quirks
3 Ways to Transpose Excel Data (Rotate Data from Vertical to Horizontal or Vice Versa)
If you work extensively with Excel at home, at work, or in a home office, you can set up your worksheets exactly the way you want. However, everyone has their own quirks and methods for working with Excel. Some prefer to organize data in columns, others in rows.
If someone gives you an Excel file and you want the data to appear in a different order, you can easily change columns to rows and rows to columns using Excel’s built-in Transpose feature. There are essentially two ways to transpose data in Excel: by copying and pasting or by using the Transpose feature. While both will transpose your data, they work differently, which I’ll explain below.
Suppose someone gives you an Excel file with the data in columns and you would rather display the data in rows.
