Compacts an input data flow by pivoting it on a column value, making it less normalized. The input data should be sorted ...

Compacts an input data flow by pivoting it on a column value, making it less normalized. The input data should be sorted by the pivot column because a pivot happens each time data in the pivot column changes. Note: duplicate rows will cause this transformation to fail.