Challenge #63: Data Preperation Using Pivot Tools

[Shifty]

If there was a wrong way to get the right answer, I think I nailed it.

Spoiler

[AkimasaKajitani]

Good Challenge.

My solution. 

Spoiler

[anshuverma0912]

Hi, Here is my solution. I tried to solve this earlier as well but I was not very well acquainted with various transform tools. This time I was able to crack it. I am Happy!!

[JoePC]

Solution Attached

[LukaszKarpinski]

My solution below:

Spoiler

[A2H]

Spoiler

[michael_leoni]

Spoiler

Please see my solution 

[ehughes]

My solution

Spoiler

 

[PeteI]

Attached my solution. Enjoyed this one and looking forward to looking at some of the alternate solutions! Thanks!

Spoiler

 

Would love to do more challenges like this for consolidating crosstab/transpose knowledge and also because I currently work somewhere where we often get many pesky Excel files to integrate into reporting.

[WernerE]

Tried to make the flow as dynamic as possible just in-case more columns are added

Spoiler