2. Configure

Check the Grouping Elements that can be used to group a set of rows together (e.g., the Source column in our example), which will be turned into a single record containing a value for each new column. The selected column(s) will be part of the output as well.

Set Pivot Element to the names in the rows that will correspond with the names of the new columns (e.g., the Type column in our example).

The Value Element should be set to the values that will be moved from separate rows into the values of the new columns (e.g., the Value column in our example).

To automatically generate the new column names from your data, select Automatically Generate Column Names, and the field below will be automatically filled in with names after you close the dialog.