Removing DataRows based on Column Value

I am currently working on sorting Excel data into a Data Table. I am running into issues where there are multiple rows for a vendor with a ship # but different item #'s under the same ship#.

Ship: 2222 Item: 44444
Ship: 2222 Item: 55555

What I want to do is cycle through the data table and remove all duplicate Ship No’s.

Have a look here:

it has an activity: Remove Duplicates

as an alternate we can

  • readin the excel into a datatable
  • removing duplicates with e.g. LINQ
  • write back to Excel