I have this excel sheet where I want to:
- Remove all duplicate rows based on the column named “PO”.
- Keep all the duplicate rows ONLY based on the column named “PO”.
I tried the first part to remove duplicate rows but it is keeping a record of one of each row and and deleting the rest.
I used this:
dt.AsEnumerable().GroupBy(Function(x) convert.ToString(x.Field(of object)(“PO”))).SelectMany(function(gp) gp.ToArray().Take(1))
Modified_ASOS_June.xlsx (21.8 KB)
Can you help me please?
RemoveDuplicateRows (1).xaml (6.4 KB)