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#.
ex
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.