Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
What baffled me for quite some time was trying to figure out how to address states that appeared in the "Missing States" but is actually in the 1920s listing.. (that implied that the state wasn't missing to begin with, right?)
Rereading the question again and again eventually solved my quandary!
Additional learning point was that renaming the fields often to standardize will help with using Union tremendously.
Even though you could do all of these transformations with spatial tools, I prefer to use the formula tool and spatial functions when possible. Here's my solution!
Think I've got this although it took me forever to actually understand what I was supposed to do