Challenge #63: Data Preperation Using Pivot Tools

[daniel_ferreira]

Follow my solution file attached...

Spoiler

[StevenBetts]

I'm sure there's a more elegant solution to my one here. Looking forward to reading through everyone else's. :)

[KOBoyle]

Solution attached.

Spoiler

[kelly_gilbert]

Good, useful practice! I'm pretty sure we've all had to work with an Excel file like this at some point!

Spoiler

[CHarrison]

Tricky fiddly, but got there in the end 

[danilang]

Slightly different form most in that I treated both header rows together.

Spoiler

Dan

[neilgallen]

Absolutely certain there is a MUCH simpler way to go about this, but hey, it's early and i'm not fully functioning mentally just yet.

[kat]

Repeatable, but my joins got a bit twisted :)

Spoiler

[yavdaanalytics]

Here is my solution. Might not be as slick as others which I need to dig through.

Spoiler