Need a Excel manipulation Solution

[Iswarya_P1 (Iswarya P)]

Attached is the Excel Data,

My task would be, if the Items column has the same values, to add the Quantity Values and remove the duplicate one from the excel

The expected output would be,

[Shiva_Nikhil]

@Iswarya_P1

Use this query

Datatablevaraible.AsEnumerable.GroupBy(Function(r) r(0).tostring).select(function(grp) grp.first).CopyToDataTable

r(0) is the index of the first columns

[ppr (Peter)]

In general we can handle it as a Group by case

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[ppr (Peter)]

@Iswarya_P1

My task would be, if the Items column has the same values, to add the Quantity Values and remove the duplicate one from the excel

from the table we would derive (as AZZ700 is not summing up the Units) that the grouping is to be done over Items, Descr and Units Columns

Assign Activity
dtResult = dtOrig.Clone

Assign Activity
dtResult =

(From d in dtOrig.AsEnumerable
Group d by k1=d("Items").toString.Trim,k2=d("Descriptions").toString.Trim,k3=d("Units").toString.Trim into grp=Group
Let cnt = grp.Sum(Function (x) CInt(x("Quantity").toString.Trim))
Let ra = new Object(){k1, k2, cnt, k3}
Select r = dtResult.Rows.Add(ra)).CopyToDataTable

We would assume that we cannot always rely on same descriptions. Maybe we have to adapt, when this is needed