How do I combine two spreadsheets and delete the duplicated info

[Guest]

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 (e-mail address removed)
2 345 USA
3 Finjar 216 UK
4 Finjar (e-mail address removed)
------------------------------------------------------------------------------------------
I would like it to end up like this:
i.e. Name Badge Country Email
1 Benny 345 USA (e-mail address removed)
2 Finjar 213 UK (e-mail address removed)
------------------------------------------------------------------------------------------

 

[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.