Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI admit this one was a tough one. Thanks to @LordNeilLord for keeping me on track :)
In my build I leveraged the solution from @LordNeilLord with a few tweaks and twists here & there. I used a Formula tool vs Data Cleansing one to help speed up the running time a bit and to help with overall performance.
Standard macro:
Workflow:
Basic case w/o blanks.
Solution to all 3 inputs.