expand pivoted data

Supposed a pivoted dataset can be expanded further particularly from rows to column. Does ETL can transform on what appears to be a pivoted or grouped data?

Advanced ETL has a function called UnPivot. It can accept an unnormalized dataset and transforms it into a normalized version by expanding the values from multiple columns in a single record into multiple records with the same values in a single column.

Supposed you have the following dataset.

After the transformation, we should be able to come up with the following.

Hope this answers your question