Figure E Quickly applying a few formats to the subtotals and grand total in Excel helps them stand out a bit from the data by moving them to a column of their own.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.