We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The Batch macro approach was my first instinct, but then I got through the more 'standard' route! @MichalM, nice to see yours completed the way I imagined it in the first place (and failed to deliver, sigh!)
This is a great challenge for that data prep type thinking; and solutions can be a lot simpler than people think.
Fortunately, I've been presented with this problem a few times over the last 6 months so I found my way through it relatively simply!