TRANSPOSE Formula Generator
TRANSPOSE flips a vertical range into a horizontal one, or the other way around. Live — changes in source update the transposed copy.
Syntax
=TRANSPOSE(array)Try it — generate a TRANSPOSE formula
Examples
Flip column to row
=TRANSPOSE(A1:A10)Column A1:A10 shown as a horizontal row.
Flip a table diagonally
=TRANSPOSE(A1:D20)A 20-row × 4-col table becomes a 4-row × 20-col table.
Static transpose (Excel)
Copy → Paste Special → TransposeNot a formula — one-time flip that breaks the link to source.
Tips
- ✓In older Excel (pre-365), enter with Ctrl+Shift+Enter as an array formula.
- ✓In Excel 365, Google Sheets: just press Enter — dynamic arrays handle it.
- ✓TRANSPOSE is live. Use Paste Special → Transpose for a one-time static copy.
Related Formulas
ARRAYFORMULA
ARRAYFORMULA applies a formula to an entire column or range at once, eliminating...
UNIQUE
UNIQUE returns a list of distinct values from a range, removing duplicates. It's...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free