Unpivot columns

The Unpivot columns step display the data based on each value from the identified column(s) with its correspondent row cells and column headers.

Input/output

The input data we'll use for this step is a table of colors and quantities for products.

Below is a screenshot of our output data after using this Unpivot columns step. The Identified column name is "Color", the "Products" column is taken from correspondent columns headers and the "Quantity" column taken from correspondent row cells.

Settings

Pick the dataset, type in "Column identifiers" the column names or indexes that will be considered as unique identifiers during the unpivot process. Multiple columns separated by comma,

then, type the "New column - pivot" and "New column - value"