TRANSPOSE

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

Syntax:

TRANSPOSE(matrix: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. http://mathworld.wolfram.com/Transpose.html