Combining data from two excel files and removing duplicates

Hi Guys…
As a person who didn’t major in computer language or is not talented with talking to robot, i need you guys help…

I have two excel files as below.
They have a common column called “Supplier”

Now, I’d like to pull supplier data from each file and extract duplicates, but with other columns in Supplier List (To be shared).

Existing supplier list (To be shared).xlsx (24.3 KB) Supplier list (to be shared).xlsx (10.4 KB)

I tried to use filter data table and build data table, but it’s not working…

Min

You want only the distinct value from both the excel files ?

If yes than try this
Filter based on one column -

yourDT.DefaultView.ToTable(true, "ColumnName")

Filter based on more than one column -

yourDT.DefaultView.ToTable(true, "ColumnName1", "ColumnName2"...."ColumnNameN")

1 Like