GroupBy + Unpivot + Pivot

Hi

I created this post just to document my strategy for inserting values into columns (Unpivot). To achieve the desired result, I had to perform an UNPIVOT and then a PIVOT.

Here’s the step-by-step process:

1. I have a table that was grouped by a “GroupBy node”.

2. I needed to use the Unpivot Node to change the structure.

3. I had to use PIVOT to change the structure again.

AS IS

MY GOAL TO BE

GroupBy

Unpivot

Pivot