FormulaCraft

TRANSPOSE

TRANSPOSE rotates a range or array so that its rows become columns and its columns become rows. In older Excel versions it must be entered as a legacy array formula with Ctrl+Shift+Enter; in Excel 365 and Google Sheets it spills automatically. Use it to reorient data without copying and pasting manually.

Excel
=TRANSPOSE(A1:C2)
Google Sheets
=TRANSPOSE(A1:C2)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Q1Q2Q3
100200300

=TRANSPOSE(A1:C2)→Q1, 100 | Q2, 200 | Q3, 300

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A1:C2 is the source range — it has 2 rows and 3 columns.
  2. 2TRANSPOSE flips the dimensions, producing an output that is 3 rows by 2 columns.
  3. 3In Excel 365 / Google Sheets the result spills automatically; in older Excel use Ctrl+Shift+Enter.

Need a version for your data?

Try: “Flip my table so the rows become columns”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: