TRANSPOSE
Returns the transpose of an array.
Lookup & ReferenceLookup & Matching Essentials
What it does
Flips rows to columns and vice versa.
Syntax
TRANSPOSE(array)
Arguments
array(array) — Array to transpose.
Examples
Transpose Table
Flip rows/cols.
FORMULA
=TRANSPOSE(A1:B2)
RESULT
[1, 3; 2, 4]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |