Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThank you, @Hollingsworth, this was a neat challenge!
I could have used 'Cross Tab' and 'Transpose' tools, but I've decided to use CReW 'Add Totals' macro instead which I love to make it a bit simpler :)
The data of solution need some cleansing to fully comply with the question.
C434
C434