How to group rows and then sort them intact

I tried searching for this topic and saw some others had asked the same thing, but there really weren't any answers to the issue that I could find.

I have a list of donors to a ballot proposition and the amounts that they've donated. Some donors have multiple line entries.

I would like to be able to group each donor and all of their donations, and then sort the list with their individual subtotals ranging from highest (at the top) to lowest.

I'm attaching the Excel file....it's public information so no need to worry about privacy issues.Donors2.xlsx

That seems perfect...thanks! Any chance of finding out how you accomplished that?

Thank you!