Opposite of consolidation...

[Lauren2324]

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

[#2]

You could sort the columns showing each name in alphabetical order

[#3 · Accepted solution]

@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:

[#4]

@Patrick2788 Thank you! I will try this and come back if I have more questions. It looks like what I need though.

[#5]

You're welcome!