Hey Mike, need your urgent help I have many entries for contact details of people which includes first name, last name, phone, address, email, location, pin, etc. Many entries are repeated. I have found out duplicate entries via email ID. But the problem is some entires have phone, address filled and some do not have out of the duplicate entries. So i want to remove duplicate entries but make sure the data in the filled cells gets copied to the empty cells while removing duplicate. Is it possible?