TRANSPOSE

The numerical or string values to transpose. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

TRANSPOSE transposes the specified data range. It changes the horizontal and vertical orientation of the data range (that is, the first row of data becomes the first column, the second row becomes the second column, and so on).

The transposed data range must be rectangular. Any empty cells in a numerical column are replaced with zeros. Empty cells in a string column are replaced with the empty string ("").

Examples

TEMP = TRANSPOSE(COLUMN(1,2,3))

Creates three new columns named TEMP, VX, and VY, each containing a single value 1, 2, and 3.

TEMP = TRANSPOSE(MERGE("a","b"))

Creates a new column named TEMP containing a and b.

TEMP = TRANSPOSE(V1)

Creates a new column for each row in column V1. Each column contains one value, the corresponding row value of column V1.

TEMP = TRANSPOSE(V1:V3)

Creates one new column for each row of the longest column, V1, V2, or V3. Each column has three rows containing the transposed values of V1:V3..

TEMP = TRANSPOSE(V1[10:15])

Creates six new columns, each containing one row. The first column contains the value from V1[10], the second column contains V1[11], and so on.

TEMP = TRANSPOSE(V1[50:99]:V2)

Creates 100 new columns. Each column has two rows containing the transposed values of rows 50-99 of columns V1 and V2.

Related Functions

Function	Description
COLUMN	Creates new column(s), vertically concatenating the input values in each column
MERGE	Creates a data group by horizontally concatenating the input values