Pivot view of data into another sheet
I have organized my original sheet by Client name to show the multiple people (contact list) working on that job along with their start dates. I would like to create a second sheet to show organized by people all of jobs they are working on and when to see if they are overloaded during a timeframe. Sometimes the people could take on different roles (see "Steve" below) How can I pivot this information into a new sheet to capture all clients "Steve" is associated with regardless of where his name appears? And also include any new clients added to the original list or if a job is reassigned to "Steve" from someone else?
Desired new view for new sheet:
Really appreciate any help!
Help Article Resources
Check out the Formula Handbook template!