Krazy4Real
Lifer
Is anyone here really good with excel? I want to do something, but I'm not sure how to do it.
I have multiple worksheets with different information in them regarding a common contact id. How do I combine them into one worksheet so that all of the data is in one place.
Each worksheet has a contact_id field with the contact number in it.The first worksheet has contact id, first name, last name, title, company. The second worksheet has contact id, address, city, state, zip, and country. The first worksheet has all the contacts in it but the second worksheet does not. Therefore, I need to add the address information when it's available for a contact, but skip it if there is nothing there.
I hope that makes sense. Let me know if you need anything clarified.
------------------------------------
There is a forum labeled Software for Windows.
Senior Anandtech Moderator
Common Courtesy
I have multiple worksheets with different information in them regarding a common contact id. How do I combine them into one worksheet so that all of the data is in one place.
Each worksheet has a contact_id field with the contact number in it.The first worksheet has contact id, first name, last name, title, company. The second worksheet has contact id, address, city, state, zip, and country. The first worksheet has all the contacts in it but the second worksheet does not. Therefore, I need to add the address information when it's available for a contact, but skip it if there is nothing there.
I hope that makes sense. Let me know if you need anything clarified.
------------------------------------
There is a forum labeled Software for Windows.
Senior Anandtech Moderator
Common Courtesy
