Resolve Multi-Select Choices into single lines
I have about 25 identical project schedule sheets. Each task has a flag indicating if it is a milestone that is also a change event (someone's job is changing). I'd like to create a sheet and calendar of all change events aggregated from all these sheets.
Workgroup Impacted (multi-select)
I'd like to end up with an aggregated sheet (all 25 projects) that has a row for each individual workgroup selected and the project name, event name, and date associated with a change event. e.g. if Workgroup A and Workgroup B are both selected for Project 1 Event 1 on 30 APR, and in another project sheet Workgroup A and C are selected for Project 2, but for different change events, I'd like four rows:
Workgroup A, Project 1, Event 1, 30 APR
Workgroup B, Project 1, Event 1, 30 APR
Workgroup A, Project 2, Event 4, 15 JUN
Workgroup C, Project 2, Event 7, 01 SEP
Any ideas how to do this?
Is there a different approach that may work better?
Thanks for the assist!