Final Friday Fix: September 2019 Challenge

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

A Pivotal Transformation?

Welcome to this month’s Friday Fix. For September, we are again pulling inspiration from a recent consulting problem. We were presented with data similar to the following:

However, our client wants it presented as follows:

It’s neither a pivot nor an unpivot, but something in between… Maybe Power Query is the solution to his one (hint, hint)..?

This is the challenge this month: can you find a solution that will allow you to automatically transform the first table into the second one?

Sound easy? Have a go. We’ll publish what we think is the best solution in Monday’s blog. Have a great weekend!