UNPIVOT

Converts a column-based range of values to a row-based range of values.

Syntax

UNPIVOT(range; headerRange; numRowElements)

1. range - the range whose content should be converted from a pivot structure into a row-based structure - Value type: a range of any data

2. headerRange - a range containing the column attributes of the pivot range - Value type: a range of any data

3. numRowElements - specifies how many starting columns from range should be used for the rows of the result range - Value type: integer (optional, default value: 1)

Remark

• The function converts the pivot structure of range into a row-based structure, with the help of the attribute names of headerRange.

Examples

Example 1 - UNPIVOT with one attribute row and one attribute column (in the #header widget). The cell “Country” in the header is ignored, because it is assigned to the row attribute.

Example 2 - UNPIVOT with two row attributes.