Athennian has created a tool that allows you to merge multiple addresses or to clean up multiple entries of one address in the database.
To merge multiple addresses or to clean up multiple entries of one address of a person, follow these simple steps:
Navigate to the People tab;
Go into the profile of the person whose addresses you would like to modify;
Go to that person's Addresses section;
Check off the addresses you would like to either merge or clean up;
At the top of the list, select # Selected and then select Combine from the dropdown list;
A new window will pop up showing you the details on the different addresses and you will notice two sections: Primary Address and Replaced Address - the Primary Address will be the surviving address;
If you would like to swap out the Primary Address listed for one of the replaced addresses, simply hover over the desired Replaced Address and select Set Primary to swap it in;
Once you will have arranged the addresses, select Confirm - note: once you select Confirm, a window will pop up advising you that the Primary Address will inherit all associations and references from the replaced address listed;
Click Yes to confirm.