Sorry if the title isn’t clear, but I need to take a schedule that’s on one sheet and break out the tasks by the people that are doing them. This is on a gdoc spreadsheet, and it’s pretty big, so lookups aren’t an option as they’re too heavy.
So does anyone have a lightweight way to take something like this:
TASK OWNER(S)
blow nose adam
go home adam, bob
make sandwich adam, chris
tie shoes bob
break bottles bob, chris
jump around chris
and on the other sheet spit out this:
adam blow nose go home make sandwich
bob go home tie shoes break bottles
chris make sandwich break bottles jump around
I can use iferror and search to ascertain whether the name appears in column B of first list, so I got that. What I can’t figure out is how to populate the tasks in the second table without using lookup.
Thanks in advance if anyone can help.