Filter Datatable and only keep items that are duplicated in one Column

[ppr (Peter Preuss)]

@yusuf_aziz
Have a Look to the Link below. Here are different scenarios showcased and identfying duplicates by 1 column is Part of IT

Linq query to identify duplicates and delete both entries

@Charmaine_Matsaudza Welcome to the forum find following starter help implementing different scenarios find duplicates by 1 key column find non duplicates by 1 key column find duplicates by 1 Key column and keep first from duplicates + non duplicates FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)