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:Please Login or Register to view this content.
Any ideas?Please Login or Register to view this content.
Bookmarks