Challenge #63: Data Preperation Using Pivot Tools

[Flo_P]

Spoiler

Didn't enjoy it much, clearly need more training on finding solution approaches for these kinds of problems.

[Nolan]

Here is my solution! Tough challenge for me - I did not have much experience with the Transpose/Cross Tab tools when I attempted it and it took me a second to catch on to the idea of matching F2/F3/etc. to headers in the data since there were multiple things it can translate to. Re-visited my original solution after completing some of the other challenges and re-did the latter half in a way that felt much cleaner. Great learning experience!

Spoiler

[benjimoser]

My Solution

Spoiler

[Archie_bos]

Here is my solution. I'm not too sure why some of the Totals in the solutions are 0? 

[CeliaC_Silje]

Spoiler

[Hammad_Rashid]

[mdm]

Spoiler

Here's my solution.

[john-sundblom]

This was my first challenge, and I used the Select Records rather than the Sample Tool at the beginning and had help of renaming columns from the solution, but was able to most the rest on my own. I just can’t upload the file where I have the designer software installed as it is restricted by my firm to upload the file.

[chandler-gjino]

attaching my solution

[SaraHamdoun]

Spoiler

Here's my solution: