How do I combine two spreadsheets and delete the duplicated info

  • Thread starter Through Being Cool
  • Start date
T

Through Being Cool

I would like to combine two spreadsheets into one and delete the duplicated information. I can put them together easy enough, but I can't seem to find a way to automatically find and merge rows that carry incomplete or duplicated information.
------------------------------------------------------------------------------------------
i.e. Name Badge Country Email
1 Benny 345 [email protected]
2 345 USA
3 Finjar 216 UK
4 Finjar [email protected]
------------------------------------------------------------------------------------------
I would like it to end up like this:
i.e. Name Badge Country Email
1 Benny 345 USA [email protected]
2 Finjar 213 UK [email protected]
------------------------------------------------------------------------------------------
 
D

Dave Peterson

It's difficult to see how you matched up your test data.

If you know that Badge# is a common field for both records or even Name, you
could do some sorting first and group that way.

But your data looks even more "special".

(Finjar had badge #216 or #213--typo in post or something funny in your data???)

==
Or even if you could say row 1 and 2 are together, 3&4, 5&6, ..., it could be
possible.
 
Top