I have the following table
Addressee Amount Total Payments Total Due Price A Merge
Apple $10.00 $20.50 $50.15 $8.00 Yes
Prune $11.00 $32.50 $30.15 $4.00 No
Cherry $7.00 $8.50 $10.90 $1.00 No
Apple $21.00 $10.20 $30.45 $5.00 Yes
Orange $11.00 $14.20 $10.45 $2.00 No
Orange $11.00 $15.20 $10.45 $2.00 No
I want to combine alike Addressee's and add the values in those fields. The result would be the below. Is there a way to get that done?
Addressee Amount Total Payments Total Due Price A Merge
Prune $11.00 $32.50 $30.15 $4.00 No
Cherry $7.00 $8.50 $10.90 $1.00 No
Apple $31.00 $30.70 $80.60 $13.00 No
Orange $11.00 $14.20 $10.45 $2.00 No
Orange $11.00 $15.20 $10.45 $2.00 No
There may be multiple duplicates, but I want to merge only the ones that say "Yes" for column Merge