Compare Two excel files for differences

SouravKayal

Hi Team, 

I have two files with data of a ID and Name and need to compare both to see any differences week over week

Table 1

ID                Name

513450         XYZ

513450         ABC

11111           6789AF

513130         XYZ

Table 2

ID                Name

513450         XYZ

513450         DEF

11111           6789AF

11111           ABC

513130         XYZ

513130         ABC

513450         ABC

the output should be

513450         DEF

11111           ABC

513130         ABC

i was trying with a record id and transpose , but dint work through. Greatly appreciate the help

Deano478

Hers is one way of doing it 

Test.yxmd