Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAYou should add multiple input files with different data sets & structures to this example to better show the value in doing it these ways.
My Solution :
Fun with regex functions , multi-row forumula's. Inspiration from official solution.
Here's are my solutions!
Couldn't think of a second creative solution, so I settled with the simplest one. Hopefully it's admissible!