Hi all, Guessing this is a popular question, yet when I am searching the existing questions I've not yet found the solution. There's gotta be an easy fix.... right???
We've a base listing our clients. Each client might have between 1-3 staff assigned to support that client. For example:
- Steve, Jill, Carl supporting Client A
- Steve supporting Client B
- Jill supporting Client C
- Carl supporting Client D
If I group the sheet by 'Assigned Staff' I get a list that looks Similar to above, but I am trying to produce a sheet that looks more like:
- Steve Supporting Client A + B
- Jill Supporting Client A + C
- Carl Supporting Client A + D
Whats the easiest way to achieve this? Would LOVE it if there is a known video out there that can walk me through the steps.
❤️
