Forum Discussion
Opposite of consolidation...
I have a workbook containing data for scheduling referees over a multi-day tournament on multiple fields.
Referee names appear under 2 columns; Umpire 1 or Umpire 2
Game assignments change every hour.
I need to print individual schedules for each referee (121 in this tournament) with the data for these headers:
Day, Time, Field, Umpire 1, Umpire 2
Please help!
Thanks, Lauren
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:
4 Replies
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!
- You could sort the columns showing each name in alphabetical order
