Delete rows from DT where column1 is same and column2 is empty

@markosc

dt.AsEnumerable.GroupBy(Function(r) r(0).ToString).Select(Function(grp) If(grp.Count=1,grp.first(),grp.Where(Function(a) a(1).tostring.Trim<>“”).first())).copytodatatable

use this

1 Like