TRANSPOSE

Converts an n×m matrix or range of cells into its m×n transpose.

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.