TRANSPOSE Function Explained

The TRANSPOSE function in Microsoft Excel allows users to switch the rows and columns of a given range of cells. It takes an array of cells as an argument and returns a transposed version of the array.

TRANSPOSE Function Syntax

TRANSPOSE(array)

  • array: The range of cells to be transposed.