Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution attached. Took a little under 10 min as was not clear at first that needed to filter on the summer season.
This was a cool exercise to get me started with Alteryx.
Took around 8 mins, the regex took more experimentation than I thought, in hindsight, should have just used the text to column tool instead lol.