A measured TRANSPOSE gallery: shape swaps, rotated indexing and unchanged totals, every value engine-verified. Live, editable, free.
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) 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.
| Expression | Result | Why |
|---|---|---|
| =INDEX(TRANSPOSE(A2:A8),1,1) | Alice | First name after flipping the column |
| =ROWS(TRANSPOSE(A2:A8)) | 1 | 7-row column → 1 row |
| =COLUMNS(TRANSPOSE(A2:A8)) | 7 | …→ 7 columns |
| =INDEX(TRANSPOSE(A2:A8),1,4) | Carol | 4th name across the row |
| =SUM(TRANSPOSE(C2:C8)) | 1500 | Total unchanged by rotation |
| =ROWS(TRANSPOSE(A2:C8)) | 3 | 7×3 block → 3 rows |
| =COLUMNS(TRANSPOSE(A2:C8)) | 7 | …→ 7 columns |
| =INDEX(TRANSPOSE(A2:C8),3,1) | 100 | Row 3 col 1 of the rotated block |
| Expression | Result | Why |
|---|---|---|
| =ROWS(TRANSPOSE(A2:A8)) | 1 | A 7-row column becomes 1 row |
| =COLUMNS(TRANSPOSE(A2:A8)) | 7 | …and 7 columns |
| =ROWS(TRANSPOSE(A2:C8)) | 3 | A 7×3 block becomes 3×7 |
| =SUM(TRANSPOSE(C2:C8)) | 1500 | Rotation preserves every value, so the total is unchanged |
Edit the grid; wrapped INDEX/SUM results update. ROWS/COLUMNS reflect the range shape.
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.
TRANSPOSE exists in every Excel version (CSE array pre-365, spill in 365), Google Sheets and LibreOffice.
| Platform | Support | Notes | Gotcha |
|---|
TRANSPOSE is one piece. The full course walks the toolkit end to end with live, measured examples.