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