Opposite of consolidation...

Lauren2324 

I think the feature 'show report filter pages' can make quick work of this task but there must be some legwork done first.

I'm guessing your data looks something like this:

Step 1: Unpivot the Ump1 and Ump2 columns:

Here's how to unpivot in PowerQuery:

Unpivot columns (Power Query) - Microsoft Support

You'll also need to duplicate a column:

Duplicate a column (Power query) - Microsoft Support

The goal is to get the data to look like this:

Step 2: Create a simple pivot table that will look like this (You can turn off all subtotals and date/time groupings):

the pivot arrangement (notice the dupe column "Copy of Value" in the filter):

Step 3: Generate the report filter pages

The sheets in the workbook after doing this: