Hey all,
I'm stuck on something and was hoping you guys can help me. Say I got information from two different sources. One has First Name Last Name and SS# and the other has First Name Last Name and Occupation. Both are completely out of order and there is no 1-1 relationship so there are more names in one category then the other. Regardless, I want to combine what does matchup together so it shows up as First Name, Last Name, SS# and Job all on one line. For arguments sake let's say all the names match up exactly and there are no duplicate names. The data would be in one spreadsheet and look kinda like this:
So if the first name and last name match in either group I want the data combined. In the above example the data would come out to be:FNAME LNAME SSN FNAME LNAME JOB Joe Williams 4567 Philip Stevens Sanitation Karen Branch 2180 Patrick Crick Mailman Philip Stevens 6700 Joe Williams Barista Jenny Reid 0021 Karen Branch Finance Jose Rodriguez 7821 Sheila Connor 2255
Any ideas?FNAME LNAME SSN JOB Joe Williams 4567 Barista Karen Branch 2180 Finance Philip Stevens 6700 Sanitation
Bookmarks