Want to get involved? We're always looking for ideas and content for Weekly Challenges.
As noted by others, New York City should be included in the solution output as not all leagues are present in this City.
here is the solution
My quick solution: (thought it was easier to use multirow vs find replace)
My solution varies from the expected output since New York city is not contained in the expected output and should be. This seems to agree with other solutions posted so I am comfortable with my solution differences.