Grouping and eliminating excel columns

[Manish540 (Manish Shettigar)]

@Meyammai Check this below link,

How to group by multiple columns from a datatable

@491114473 Have a Look Here for an example with 1 Key In your Case a linq could Look Like following (From d in dt.asenumerable Group d by k1=d(0). toString.trim.substring(0,10), k2=d(1).toString.trim Into grp=group Let s= grp.sum(function (x) CDbl(x(2).toString) Let ra = New Object(){k1,k2,s} Select dtResult.rows.add(ra)).copytodatatable dtResult is Just an empty datatable with the needed Output structure. Often IT can be Cloned from Origin datatable with dt.clone Statement. Expect som…

Hope this may help you