Hi

The attached example has 2 tables. The first table contains 4 records showing the numbers of apples which John and Sam have in different boxes,

Name,#Apples,BoxNumber

John,5,1

Sam,2,2

Sam,7,1

John,1,2

I want to consolidate the rows into a new table showing that John has 6 apples and Sam has 9 apples (i.e. ignoring which box the apples are in).

Is there a solution using dt.rows.add?

consolidateTable.xaml (10.5 KB)

Advice would be greatly appreciated.