Unpivot converts columns to rows. The Unpivot transform is useful in condensing data and the data is often exported to analytics software for creating reports and dashboards. The result is saved as a new dataset when the transform is applied.

1. Click the Transform menu and select the Unpivot option. 

2. Enter a name for the new dataset in the New dataset name field.

3. Select the columns to unpivot in the Columns to apply box. These are the columns that will be converted into rows. 

4. A new column will be created using the column headers of the selected columns. Enter a name for this new column in the Column name for headers field.