Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAChallenge #331
Overcomplicated this one slightly, but worked!
Nice Challenge!
My results.
Nice to solve WITHOUT the summarise, although I often prefer to use the summarise before the cross tab to make it clean an aggregation is happening, and then simply reshape/pivot with the crosstab.