Challenge #436: Universal Summer Cup Stats – Part 2

[Powerhouse_21]

I think I got things semi-dynamic, but it definitely made the workflow longer.

Spoiler

 

[wbasuki]

Here is my solution

Spoiler

[stataltgee]

My solution 😁

[Carolyn]

I feel like I could've done this a bit cleaner, but I got there :) I ended up using the MOD function and RegEx_Match, since those have been my "go to" functions lately 

Spoiler

[samgiroux]

Spoiler

[oscar_leeper_wf]

Thanks Albert Bellamy for the idea to start with the tool I won't mention to spoil it.  I probably could have just used the sums.

Spoiler

[ChrisTX]

Finally got a chance to use the Dynamic Replace tool.

Spoiler

 

[ahsanaali]

Spoiler

 

[sfarnham1]

I avoid cross tab whenever I can.

[Paridhi_Agrawal]

My solution: