merge problem

[GKW in GA]

I have 2 .xls files that are fomatted exactly the same File1 contains some
rows that are not in File2 and vice versa. Each File has 4 columns. How can I
get the rows that exist in File2 that are not in File1 into File1 and the
rows in File1 that are not in File2 into File2 so both documetns contain
exactly the same thing

 

[Earl Kiosterud]

One way is to paste one under the other, then sort them, then remove duplicates, if
necessary (there's stuff to remove dups at www.cpearson.com).