Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Here is my solution.
Happy with learning experience, less pleased with results (as in too many tools use). My results joined perfectly to expected results.
I don't like Regex, too much like code not data driven, but would reduce the number of tools !
Here's my solution, for my first weekly challenge! I had to check out some of the RegEx that other folks were doing, since my text to columns approach kept leaving me with duplicate team names.
I took the long route but I documented as I traveled.
It's not pretty but it got the job done.
Attached is my solution