I have a Google Sheets with a long list of names and amounts. Many of the names are duplicates. For example:
John | 10 Bill | 2 Susan | 3 Frank | 4 Sally | 10 John | 2 Susan | 2 John | 3
Is there any automated way to combine all of the values so I get a list without any duplicate names and a single sum of all of each person's entry?
John | 15 Bill | 2 Susan | 5 Sally | 10