Transpose vs Pivot
The Tabular Transformation BizApp includes a Transpose Command that allows a the data set of delimited file to be rotated along the vertical or horizontal axis. The Transpose Command performs this action across all fields of the data set. This is not to be confused with a pivot action which rotates a single field along the vertical or horizontal axis. A Pivot Command is planned for release on June 27, 2020.
Below is an example of the result of the Transpose Command.
Raw data before Command
Data after Command