Marge row

Hello,
I have a table in Excel that looks like this
image
In column “A,” it is possible to have two or more identical numbers. How can I merge the rows so that only one row remains, and I can sum the values from column “D”?
e.g.
image

One row of value remains in column “D” 52,7

@plamenov.plamen Try with Group by sum linq query

@plamenov.plamen

(From row in dt1.AsEnumerable
Group row by sc = row(“A”).ToString()
Into grp = Group
Let total= grp.sum(Function (x) Convert.ToDouble(x(“D”).ToString().Replace(“,”,“.”).Trim()))
Let result = New-Object() {grp(0)(“A”),total}
Select dt2.rows.add(result)).CopyToDataTable

Hi

Read the excel file and store data in a datatable.

Assign activity:
mergedData = inputData.AsEnumerable().GroupBy(Function(row) row.Field(Of String)(“A”)).Select(Function(group) New With {
Key .ColumnA = group.Key,
Key .SumD = group.Sum(Function(row) Convert.ToDouble(row.Field(Of String)(“D”)))
}).CopyToDataTable()

Thank you

hi…
error

Hi,

MergedData datatype is datatable,So please check it once.

Thank you

MergetData is DataTable type