Deleting same row from Excel A to B

Help Activities
, , ,
1

I wish to attach some files but it says new user cannot attach any files so I have to explain in text.

Im in stuck with Deleting same rows in Sample 1 compare to Sample 2 and making output dt Sample3.

Sample 1 .xlsx
ID Name
1 Sam
2 Steve
3 Kim
4 Alan

Sample2.xlsx
ID Name
2 Steve
3 Kim
5 William

Sample3.xlsx ← output Excel

1 Sam
4 Alan

I’ve tried Join Datatable, For each and all other things,
Plz help me with my work.

2

Hi @Massmeguelsnn

You can refer to this link.

Thanks,
Prashant