1 data source
Unpivots a set of data. This object will take every column that you indicate and line them up into a single column called Value. A new column will be created next to is called Type, that holds the value of the column header that each data point used to be in.
Use this object if you need to change the structure of your data. If you have a table containing columns: Location, Profit, and Loss, you could use this Unpivot Object to convert it into a table with the columns: Location, Type, and Value - where Type contains Profit or Loss, and Value is the number. This means you now have a row for each locations' profit and a row for each locations' loss.
The Unpivot object is useful if you need to apply the same steps to many columns of data. Simply unpivot them (which puts all of their values into a single row), apply the steps to that column, and use the Pivot object to return the data to its original form.
Choose a unique ID column that will not be unpivoted, and will be used as a key if the data needs to be pivoted back into shape.
Choose the columns to unpivot
Optionally, you can choose to select the columns to exclude from the unpivot operation.