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!
Help Article Resources
Check out the Formula Handbook template!