Challenge #63: Data Preperation Using Pivot Tools

[sgrabish1]

Thanks for practice exercise; painful but enjoyable.

[JamesFo]

Real fiddly one!

[RobertW]

This one was certainly tricky...

Spoiler

[tonypreece]

Question two of this challenge specified a four digit code, the provided answer included a six digit code, I've done it with the first four digits of the six.

Spoiler

[JamesCameron]

My Effort. Pretty brute force tbh

Spoiler

[JamesCameron]

Spoiler

Just had a look at the provided solution. I was particularly impressed with how the dates and column name were combined. A tip to remember!

[djodts]

Here's my solution.