How to Transpose Data in Excel
Flip a table so rows become columns and columns become rows — without retyping a thing.
Last updated: August 2026
| Before (rows) | After (columns) | |
|---|---|---|
| Q1 · Q2 · Q3 across a row | → | Q1 / Q2 / Q3 down a column |
| Region names in row 1 | → | Region names in column A |
Method 1 — Paste Special → Transpose (static)
- Select the table and press Ctrl + C.
- Right-click an empty cell with room, choose Paste Special, and tick Transpose.
- Click OK. Shortcut:
Alt, E, S, E, Enter.
This makes a static copy — it won't update if the source changes.
Method 2 — TRANSPOSE function (live)
- In one empty cell type
=TRANSPOSE(A1:D5)and press Enter. - On Excel 365 it spills into a live range that updates with the source; on older versions enter it as an array with Ctrl + Shift + Enter.
The 1-click way — Tellsheet's Transpose
Select the range and click Transpose. Tellsheet swaps rows and columns with a before/after preview, and it's revertable. Transpose is one of Tellsheet's free tools.
Frequently asked questions
What's the shortcut to transpose in Excel?
Copy the range, then Alt, E, S, E, Enter opens Paste Special with Transpose ticked. Or right-click an empty cell → Paste Special → tick Transpose.
Does TRANSPOSE update automatically?
Yes — the TRANSPOSE function stays live and updates with the source. Paste Special → Transpose makes a static copy that doesn't.
How do I transpose without formulas?
Use Paste Special → Transpose for a static copy, or Tellsheet's Transpose tool for a one-click swap with a preview.
Related Excel guides
Reshape data in one click
Get Tellsheet and transpose, unpivot, split and merge data — with a preview before every change.
Get Tellsheet free See pricing