TRANSPOSE

Returns the m×n transpose[1] of an n×m matrix or range of cells.

Syntax:

TRANSPOSE( matrix:Range or Array )

You can also use this function to swap over rows and columns of other data in your worksheet.

See also the SORT() and FLIP() functions.

  1. Weisstein, Eric W. "Transpose." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/Transpose.html