Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI struggled to get the layout right, had to check the community threads for help, credit to Philip Mannering!
Ended up going to war with my Alteryx crashing over and over on this one and limitations working with the reporting cells. For some reason the crosstab tool would blow up if set to concatenate instead of first despite not actually applying the aggregation. Leaving it here so I won't be sworn off reporting tools but I'm still pretty happy with how the outcome.
My solution to challenge 98. Although I have to say the generate rows part is heavily inspired by the solution that I saw from @LordNeilLord.
Was really struggling why i have extra space after the fourth column but saw in the end that the tool with rank 157 had name which was too long.. :|