Transpose

Function

Transpose(array)

array

Transpose is included by default in each file as part of the Lookup library.

 

See also:


The Transpose function transposes the rows and columns of an array. For example, with the following values:

A formula =Transpose(Sheet1.A1:C2) gives this result:

The Transpose function works with any array, table range, vector, or matrix.