Functions
TRANSPOSE
Transposes the rows and columns of an array
Try it
When to use it
When should I use TRANSPOSE?
Use TRANSPOSE to swap the rows and columns of an array — useful when data arrives in row orientation but downstream formulas expect column orientation, or vice versa.
Used in
Syntax
TRANSPOSE(array)Examples
=TRANSPOSE({1,2;3,4}) // => 1
=TRANSPOSE({1,2,3;4,5,6}) // => 1
=TRANSPOSE({1,2,3}) // => 1