Where in the Sample Data does it show that the city is mapped to address 3??...What is the logic behind the city being mapped to Address 3 and not 1 or 2??

The Sample data is not very clear and you need to be more specific about your requirement and the Logic behind the requirement.

Please elaborate a little more on the requirement.