Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe 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!