Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy Solution 😎
Attached is my solution. This was fun and its always good to practice some regex!
inspired by @PhilipMannering
Spent a lot of time on getting the column names dynamically but ended up hardcoding it. Excited to see submissions from others.
wow, some serious Regex going on here!
This one was fun. Hard to make it truly dynamic, but I tried to make the hard-coded parts relatively simple to change. Also tried to keep the REGEX to a minimum just how much I could do without it. Managed to limit it to two simple REGEXReplace formulas.