TRANSPOSE

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.