Excel: Excel 2010 Windows 7 - create new list from different data sets


Thank you for a great resource! I have combed through the posts on combining data, but could not find one that addressed this issue: Data set 1 includes fname, lname, and 10 other fields;

Fname Lname Gender Race Data1 Data2 Data3 Data4 Data5
Jane Doe F W abc ab
Sam Roberts F W ab ab
John Jones M B a a
Data set 2 has fname, lname, and 4 different fields (not in the other set).
Fname Lname Gender Race DOB EventsAttended Active
Jane Doe M W Ab/cd/efgh ab C
I want to combine the lists so all data from Jane Doe appears in one record.
Fname Lname Gender Race Data1 Data2 Data3 Data4 Data5 DOB Active
Jane Doe F W abc ab Ab/cd/efgh
Y
John Jones M B aa a a a a Ab/cd/efg
N
NOTE: Some names might not be on both lists I am not that proficient with Excel, but can pick up quickly. Thank you for your help! Karen


This question generated 39 answers. To proceed to the answers, click here.

This thread is current as of November 26, 2013.


For more resources for Microsoft Excel