Hi Blackbeard, the Target list has a couple of locations that have suite numbers/2nd address line that are causing the parsing to shift their remaining fields over by 1, parsing these suite numbers into the city field, the city into the state field and the state into the zip code field:
Target 1884, which is in West Hollywood is showing the suite number in the city, the West to show up under state and Hollywood to show up under zip.
Target 3241, which I believe is in the Chapel Hill. You can see these when you sort Z->A under zip code.
Also, all zip codes that start with a 0 are parsing off that starting 0 (New England states = MA, CT, NE, ME, and NJ)
As always, thank you greatly for all of your fantastic work!