Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAUsed a Cross Tab tool and a Summarize tool instead of another formula to concatenate and could have collapsed the formulas into one giant formula, but that was too difficult to debug.
Very Easy with formula tool .
Impressive @LHolmes
I took the waterfall approach instead of writing nested IF formulas to visually see it working, and that is the beauty of Alteryx- every step of the way you can visually see what's happening and see how the sausage is made.