Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Used generate rows and regex but in a slightly different order. Also the data is updated to contain 2016 vs 2015 data
Thought it was going to be impossible, but it was actually not too bad!
Got a few more rows than the solution file but i think its just updated. Fun little parsing challenge
Fairly challenging! My data was from 2007 to 2016 also...great parsing exercise.
Regex to the rescue. I feel like I used fewer tools than most sooooooo..... go me.
the good old multi-row tool. And to think I did not understand/get its use the first time I came across it!
that was quite something, messy data is messy, but cleaning it feels so rewarding :-)