I have a worksheet - with days down column and tasks across rows and names in
the cells. I want to create a list of names by tasks signed up for.

example
taska taskb
mon Bob Ted
tues Alice Bob
....

and make an assignment list like

Bob taska taskb
Ted taskb
Alice taska


can I do that?