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,
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.