Sorting in descending order and show duplicate values

I have a data (sample attached). I looking for a way to sort it. When you select from drop down in C2, it sorts the table in descending order by "total spend" in column C. It does not only sort in descending but also shows names with duplicated spend.

please see attached.

thanks!!!!!