Unpivot

The Unpivot transformation command transposes input columns to rows in the output. Each transposed column value creates a row with two columns with values equal to the name of the transposed column and the value in that row.

Configuration

To configure an Unpivot command, you specify:

• Specify a name for the new column that will aggregate the values of the transposed columns.

• Select the columns to transpose to rows in the output.

• A name for the aggregated column.

• optionally, change the names of the transposed values; by default, the values will be the names of the transposed columns.