This is all about understanding the data structure then doing prep and blend as needed. Made extensive use of the sample tool to get rid of or keep rows.
First weekly challenge after receiving my core certification! Here's my solution, looking at some of the others I can see I would definitely benefit from learning more about those dynamic tools!