Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Not elegant or optimized, but got an answer quick...
My solution. Oh, Transpose & Cross-Tab, whatever did I do before I figured out how to use you...
Same solution as many. Split into 2 streams, one for the data, one for the key rows/headers.
Happy to see my solutions are starting to look like everyone else's
Here's my very long and clumsy solution! Not sure why but I couldn't get my head around this one.
Spent far too long messing around with those pivots trying all combinations of all the transform tools and finally did it in a fiddly way.... Will refer to how everyone else has done it and get my head around how to pivot data properly!