Hello I want to make this datatable fruit price apple 30 apple 50 apple 20 pear 20 pear 10 banana 20 banana 25 to fruit price apple 100 pear 30 banana 45 Please help me :slight_smile:

@hoseongwon Use the groupby function to get your desired output: (From d In dt.AsEnumerable Group d By k=d(“fruit”).toString.Trim Into grp=Group Let value = grp.Sum(Function (x) CDbl(x(“price”).toString)) Let ra = New Object(){k, value} Select dtNew.Rows.Add(ra)).CopyToDataTable regards,

Sum up same name's price + remove same name's row

Help Studio

vishal.kp (vishal) March 28, 2023, 2:02pm 4

@hoseongwon , you can refer the below thread for a brief explanation:

Topic		Replies	Views
DataTable Streamlining Activities database , uiautomation	2	1036	September 1, 2021
Merging non-unique rows in DT Help datatable , activities , question	6	1221	January 18, 2020
In DataTable find equals rows and unify them and sum values of one column Studio activities , question	7	1150	March 16, 2023
Datatable group by with sum Help	2	3859	June 24, 2019
Merge rows and add values of specific columns Help	11	4214	July 22, 2019

Sum up same name's price + remove same name's row

Related topics