Lookup & reference · reshaping · Nov 2026

The TRANSPOSE function,
measured & explained.

A measured TRANSPOSE gallery: shape swaps, rotated indexing and unchanged totals, every value engine-verified. Live, editable, free.

D1
fx
=TRANSPOSE(A2:A8)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How TRANSPOSE works

Legacy Excel: select the rotated-shape block and Ctrl+Shift+Enter. 365: spills from one cell. Values are preserved; only the orientation changes.

=TRANSPOSE(array)
arrayRequired. The range or array to rotate; an m×n input becomes n×m.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Reshaping

What TRANSPOSE does to shape

TRANSPOSE(array) rotates a range 90°: a column becomes a row and vice versa. In legacy Excel it is a CSE array formula (Ctrl+Shift+Enter into a pre-selected block); in 365 it spills. The gallery is measured live, wrapped in INDEX/ROWS/COLUMNS so each result is a single verifiable fact. Click any row.

Measured TRANSPOSE gallery

ExpressionResultWhy
=INDEX(TRANSPOSE(A2:A8),1,1)AliceFirst name after flipping the column
=ROWS(TRANSPOSE(A2:A8))17-row column → 1 row
=COLUMNS(TRANSPOSE(A2:A8))7…→ 7 columns
=INDEX(TRANSPOSE(A2:A8),1,4)Carol4th name across the row
=SUM(TRANSPOSE(C2:C8))1500Total unchanged by rotation
=ROWS(TRANSPOSE(A2:C8))37×3 block → 3 rows
=COLUMNS(TRANSPOSE(A2:C8))7…→ 7 columns
=INDEX(TRANSPOSE(A2:C8),3,1)100Row 3 col 1 of the rotated block

Shape is the whole story (static)

ExpressionResultWhy
=ROWS(TRANSPOSE(A2:A8))1A 7-row column becomes 1 row
=COLUMNS(TRANSPOSE(A2:A8))7…and 7 columns
=ROWS(TRANSPOSE(A2:C8))3A 7×3 block becomes 3×7
=SUM(TRANSPOSE(C2:C8))1500Rotation preserves every value, so the total is unchanged
⚠ Legacy entry method. In Excel 2019 and earlier, select the destination block of the rotated shape, type =TRANSPOSE(source), and press Ctrl+Shift+Enter. In 365 it spills from a single cell. A wrong destination shape is the classic #N/A error.
Bridge orientations: pair TRANSPOSE with SEQUENCE for outer products (=SEQUENCE(10)*TRANSPOSE(SEQUENCE(10))), with MMULT for matrix math, or with FILTER to reshape a spill. For a one-time reshape use Paste Special → Transpose.
// 03 — Try it live

Interactive TRANSPOSE playground

Edit the grid; wrapped INDEX/SUM results update. ROWS/COLUMNS reflect the range shape.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where TRANSPOSE works

TRANSPOSE exists in every Excel version (CSE array pre-365, spill in 365), Google Sheets and LibreOffice.

PlatformSupportNotesGotcha
✓ Supported full TRANSPOSE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master reshaping data

TRANSPOSE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • TRANSPOSE — rotate rows ↔ columns
  • CSE array entry vs automatic spill
  • Indexing the flipped axes with INDEX
  • Outer products: SEQUENCE * TRANSPOSE(SEQUENCE)
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked