Linq group by and sum for all columns without change any headers count

[sohil.b]

as per image if 2 dc no for one account so will divide interest column and paste and divide with 2 dc if account no is same for one DC then so interest will sum and also account number is group so in account no will distinct values want same excel row and column with grouping duplicate in dc and account no and result will show in interest column any linq for these

[Anil_G (Anil Gorthi)]

@sohil.b

Please explain the scenario properly…or share a file with input and output required

Cheers

[ppr (Peter Preuss)]

@sohil.b
Have a look here:

Find duplicate values in data table and do operation as per condition in the same table

Preparations: [grafik] Input: [grafik] Add Set: [grafik] (From d In dtData.AsEnumerable Group d By k=d("TransID").toString.Trim Into grp=Group Where grp.Count = 1 From g In grp Group g By k2=g(0).toString.Trim Into grp2=Group Let til = String.Join(",",grp2.Select(Function (g2) g2(1))) Let am = grp2.Sum(Function (g3) Convert.ToDouble(g3(2))).toString("F2") Let ra = New Object(){grp2.First()(0), til, am} Select r = dtAddSet.Rows.Add(ra)).CopyToDataTable SplitSet [grafik] (From d In dtD…