Challenge #49: Reformatting Transactional Data

[Garrett]

Not elegant or optimized, but got an answer quick...

[NicoleJohnson]

My solution. Oh, Transpose & Cross-Tab, whatever did I do before I figured out how to use you...

Spoiler

[estherb47]

Same solution as many. Split into 2 streams, one for the data, one for the key rows/headers.

[LordNeilLord]

Solution:

Spoiler

[MsBindy]

Happy to see my solutions are starting to look like everyone else's

[nick_ceneviva]

Solution attached

[jamielaird]

Here's my very long and clumsy solution! Not sure why but I couldn't get my head around this one.

Spoiler

[patrick_digan]

Spoiler

[data_rachel]

Spoiler

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!