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:
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.