guscrouchend
Board Regular
- Joined
- May 11, 2010
- Messages
- 94
hi,
Let's say I have 50 therapists and 100 clients. There have been 3000 appointments, with each client seeing a variety of therapists. I now want to trawl through the appointments and tabulate every client's list of seen therapists.
Each appointment is a row on BillableHours! Col K = 'Client' and Col L = 'Therapist'. (Other cols are time, price etc).
New WS -
Col A = Unique Client list (I can do this).
I would like to display in cols B (and rightwards) all unique therapists that a client has seen. If they only saw 2 therapists, those two names would populate B and C. If they saw 10, names would continue to K.
If anyone could help me do this I would be might grateful. Should I use a macro or some kind of formula?
Best wishes, it is really appreciated.
gus
Let's say I have 50 therapists and 100 clients. There have been 3000 appointments, with each client seeing a variety of therapists. I now want to trawl through the appointments and tabulate every client's list of seen therapists.
Each appointment is a row on BillableHours! Col K = 'Client' and Col L = 'Therapist'. (Other cols are time, price etc).
New WS -
Col A = Unique Client list (I can do this).
I would like to display in cols B (and rightwards) all unique therapists that a client has seen. If they only saw 2 therapists, those two names would populate B and C. If they saw 10, names would continue to K.
If anyone could help me do this I would be might grateful. Should I use a macro or some kind of formula?
Best wishes, it is really appreciated.
gus
