Removing duplicate rows based on same Number Column and same Data Columns

Help Studio
, ,
1

Hi,
I have a sheet where I want to check and remove duplicate enteries.
In this First Data column check will be there If it contains a duplicate entry than check for the number column if it also contains a duplicate entry for the same Data column than remove it.
I have attached the excel sheet for the same.

TEstingSheet.xlsx (9.2 KB)
Here is the result sheet as the output is required.
ResultSheet.xlsx (9.1 KB)
Thanks in advance!!

2

Hi,

How about the following sample?

image
image692×412 15.9 KB

dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r(0).ToString,r(1).ToString)).Select(Function(g) g.First).CopyToDataTable()

Sample
Sample20231006-2aL.zip (16.2 KB)

Regards,