Filtering data in lieu of pivot table

Hi

I have some code which sorts data and thus circumvents need for use of pivot table.

I want to change the filtering of this data to another style (see desired style tab in attached). Is this possible? Any help would be much appreciated.

Thanks

Why not use a pivot table, as they are designed to do things like this?

Because I want to avoid user having to update pivots, rather use macro