• Data Unpivot is a way of transforming data from a wide format to a linear format.
• The source data is rearranged to make it a part of a single column in the new dataset.

To transform the column data into row data

When you want to transform the data type

When not to use

—

Data containing multiple columns

A supervised data or any data in row-column format

Output

Unpivoted data with column data converted to row data

—

Limitations

—