Merging Two Sets of Contacts

[magsrog]

Hi!

I'm very new to excel but have been picking it up (relatively) quickly

Here's my problem:

I am trying to merge my boss's contacts. He has one enormous set of contacts in GMail (5000+) and one enormous set of contacts in Excel (5000+) I've exported both sets into excel but how to I merge them?

The headers for each set are in a slightly different order (Home Address, Office Address, Email ...vs.....Office Address, Home Address, Email) Do I need to make sure the order of the headers match in both the GMail Sheet and the Outlook Sheet and is there a faster way to do that than just rearranging them manually?

My second question is how do I merge them? There are a lot of over-laps of people but some info might be different in Outlook than in GMail. For example I might have John Smith as a contact in both Gmail and Outlook but two different email addresses for him under the header "Email 1" how do I make sure one email doesn't eliminate the other? I just want to merge both sets of contact info for each person into one super contact.

Does that make sense? I know excel is full of magic tricks and I'm really hoping you guys can help me!

Any advice would be greatly appreciated!

Thanks!

-Maggie

[sathishkm]

Please can you attach the sample file.

[magsrog]

What is the best way for me to attach a sample file without including the sensitive contact information?

[sathishkm]

If you attach both the file. We can try it.

[arlu1201]

What is the best way for me to attach a sample file without including the sensitive contact information?

Ensure that the format matches your original file and replace the sensitive data with dummy data. You do not need to upload the whole file, just a few rows which are sufficient to understand the problem at hand.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.