I have to generate a report every week that contains inventory items. This report must be shown by largest to smallest dollar value. However, there are many lots of the same item, all varying in value. I have been manually cutting and pasting to group similar items together, but is there a shortcut to do this?
For example, if the report is showing: Product A $100, Product B $75, Product C $70, Product A $50, Product D $45, Product A $25.
I want it to be sorted: Product A $100, Product A $50, Product A $25, Product B $75, Product C $70, Product D $45
Essentially, I want to sort largest to smallest by value, then alphabetically, but displaying alphabetically similar items next to each other under the highest dollar value. A sort within a sort, so to speak.

I have tried messing around with the sort function and didn’t have much luck. I have also tried the “group” function and that didn’t keep similar items together when I sorted largest to smallest by value. I have the ability to use a VBA script, but I’m not familiar enough with VBA to generate my own script. This report also varies every week so I don’t know if that would even work? Pivot tables are also not an option here since there is other information in other columns that need to be easily displayed and don’t work with the formatting of pivot tables.