Look for the duplicate columns in A column and add all the values in B column

Help Studio
1

Hi everyone,
I have one excel where it will contain duplicates in column A of it has mean it sholud add all B column values and past it as unique row

The image shows an example of input data with two columns, grouped by labels in 'Column0', and its corresponding summed values in 'Column1' calculated and presented as output, where 'A' sums to 30 and 'B' sums to 20. (Captioned by AI)
The image shows an example of input data with two columns, grouped by labels in 'Column0', and its corresponding summed values in 'Column1' calculated and presented as output, where 'A' sums to 30 and 'B' sums to 20. (Captioned by AI)1920×2560 69 KB

2

@Gopi_Krishna1

Try this in assign

dt = dt.AsEnumerable.GroupBy(function(x) x(0).ToString).Select(function(x) dt.LoadDataRow(x.ToString,x.Sum(function(y) cdbl(y(1).ToString)).ToString},False)).CopyToDataTable

Cheers

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.