Attached to this listing is two data files. This is what I need done.
1. In List 2 I need the addresses separated into "Street" "Suite" "City" "State" and "Zip"
2. I then need this list added to "Master"
3. Finally I need the duplicates removed from the Master once the two lists are combined.
Some records are not complete but should not be removed.