TRANSPOSE

Syntax:

TRANSPOSE ( array )

Description: Creates a new array that is the transpose of an existing array, by copying the first row of the existing array to the first column of the new array, the second row of the existing array as the second column of the new array, and so on. The formula containing the call to TRANSPOSE shall be an array formula in a range that has the same number of rows and columns, respectively, as array has columns and rows.

Arguments:

Name

Type

Description

array

array, reference

The set of values to be transposed.

Return Type and Value: array – The new array.

example: