Transposes the rows and columns of an array or range of cells.
Sample Usage
TRANSPOSE(C2:F9)
Syntax
TRANSPOSE(range)
- range - The array or range whose rows and columns will be swapped.
Examples
TRANSPOSE(C2:F5) transposes the rows and columns of the range C2:F5.
Notes
- Transposition operates such that the value in the nth row and mth column will become the value in the mth row and nth column. The result of a transposition on a range of size m rows × n columns is n rows × m columns.