Report Grouping based on Multi-Select Drop Down, with the same "data" listed under multiple groups
I have a list of technicians who support calls from different phone queues. I need a report that will group all technicians who support each one. And as in any call center, technicians never support a single queue and will therefore need to show up under each queue group.
This is what my sheet would contain:
And this is what I would like to have my report look like:
At first I tried creating reports to contain each skill, and then soon realized I cannot add "reports" to a report, only sheets to a report. I've thought about having several sheets, but then the question is how do I keep them all updated when updating the master sheet? I only want one source for entry and updates, rather than having to go manually update several sheets with the same information.
Any advise would be appreciated!