Forum Discussion
Opposite of consolidation...
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:
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:
Patrick2788 Thank you! I will try this and come back if I have more questions. It looks like what I need though.
- You're welcome!