How to Merge two excel in one file without having duplicate value

Question

I want to add two file into one file without having duplicate values.

E.g.- File 1 - Header - 1 2 3 -  Row wise data -1st Row A B C 2nd row - D E F 3rd Row - G H I

File -2 Header - 1 2 3 -  Row wise data - 1st Row J K L   2nd row - A B C  3rd Row - M N O

Output file require - Header -1 2 3 Row wise data - 1st Row A B C ,2nd row - D E F , 3rd Row - G H I , 4th Row J K L  5th Row - M N O.

MichalM · Accepted Answer

@Rajeev18

You can blend the two using the Unique tool - align the columns automatically by their name - and then run the stream through the Unique tool to only get non-duplicated rows

Rajeev18 · Accepted Answer

Thanks you so much. It worked.