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.
SORT
FLIP