Functions for manipulating and filtering address information
 

There are 3 things I am attempting to accomplish

1. If a cell is blank, I want to populate the cell with text from an
adjacent cell while removing the text from the adjacent cell

2. I have a list of addresses. I want to filter the list to remove
duplicate names & addresses and retain the row which contains the most
information. For instance, I may have 2 entries for the same person with
only one entry containing phone number and email address info. How do I
filter this information to retain the entry with the most data?

3. Is there a search function that can be used to identify duplicates
sharing one or more columns of information?

Can anyone help?