How to Transpose in Excel: Paste Special, TRANSPOSE Function and Power Query
- Tahir Abbas
- November 18, 2026
Transposing in Excel means turning rows into columns or columns into rows. You need it when a table arrives in the wrong orientation, when a chart expects data in the other direction or when you copy a list from a report and want it laid out sideways. Excel offers three main ways to do it:

