Want to get involved? We're always looking for ideas and content for Weekly Challenges.
I went in a very round about way to get to the answer, but I got there never the less. I will probably understand the Multi-Row tool really well by the end of these challenges.
Not my best solution but gets the job done
Here is my solution
the parsing is specific to this file.
here is my solution
great one, took a while
regex is so unforgiving, but so powerful