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

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


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


Have a look here: