The duplicate record (cust ID 787) has a different number of annual transactions in each record. Your solution keeps only the first record, with the lower number of transactions but there's no way of telling which is the correct record, or if they're both correct and should be combined!
