The desired result (Final State) incorrectly has Annual Transaction value for duplicate customer Jack (ID 787) as 86, when should be 186 (sum of the 2 duplicate values from data sets Start 1 and Start 2 (Initial State). My solution has the correct (IMO) value of 186.