Merging dups

Can anyone think of a relatively easy way to combine the records of a couple living at the same address into one record? I can identify them pretty well, (same address, same last name, different first name) but I can't come up with an automated way to merge them. It's not worth the savings in postage to merge them by hand. It might be worth noting that most of our duplicates in the address field aren't really dups (eg multiple people working at the same org), which is why I'm not even thinking of trying to merge couples with different last names at the same address, & that sometimes the "couple" at the same address is really one person (eg Bill & William).

Archive Category: