turning a worksheet inside out
"Don" wrote:
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?
or the final list can look like
Bob taska
Ted taskb
Alice taska
Bob taskb
|