Pivot Transformation
The Pivot transform pivots the table based on the selected column.
The Pivot transform is used to transform the shape of the data of a report, typically by grouping by a set of columns and aggregating other columns. From Modeler Prepare, you can apply Pivot transforms to a prepared source.