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

[Rajeev18]

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 solution]

@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 solution]

Thanks you so much. It worked.