Challenge #245: Zip It Real Good

[RichoBsJ]

Spoiler

[Reesetrain]

My Submission

Spoiler

 I used 4 Joins and a Union
-I used the text to Colum tool with a hyphen to break the gaps and then add rows to fill in the gaps. I also used a formula to add the leading zeros as that was tricky.
Finally for the military addresses (AA,AP,AE) and others I used a formula to hard code the assignment

[JP_SDAK]

I feel like I used a lot of extra tools, but I got there nonetheless.

Spoiler

[grazitti_sapna]

Here is my solution to the problem.

Spoiler

Thanks.

[mustel]

Spoiler

Not sure why I needed to remove duplicates at the end... will look into it when I get more time - as is all 42,004 match

[ktroutt]

First challenged solve in a long time. 

Spoiler

[johnzrgu75]

[PriyankaaJ]

There were probably more elegant ways to do this, but my strategy was to isolate the records in Input 1 into 3 different categories based on the types of "Zip" given: entire state, rest of the state and the 1st 3 numbers of the zip. 

Spoiler

[Tyro_abc]

Spoiler

[TonyA]

Had to wait for the weekend to start playing with this one. 

Spoiler