UNPIVOT
Converts a column-based range of values to a row-based range of values.
Last updated
Converts a column-based range of values to a row-based range of values.
Last updated
UNPIVOT(range; headerRange; numRowElements)
range - the range whose content should be converted from a pivot structure into a row-based structure - Value type: a range of any data
headerRange - a range containing the column attributes of the pivot range - Value type: a range of any data
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)
The function converts the pivot structure of range into a row-based structure, with the help of the attribute names of headerRange.
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.
