Don
One way - you have to kid Excel find ount how many names there are using the
COUNTA function e.g =COUNTA(B2:C3), this is the number we work with

The formulas go in column B but before that we need to enter something into
column A that we can count a space will do - then copy this down the number
of rows you counta function gave you.

I entered this in B6:
=IF(COUNTA($A$6:A6)<=COUNTA($B$2:$C$3)/2,INDEX($B$2:$B$3,MATCH(B2,B$2:B$3,0)),INDEX($C$2: $C$3,MATCH(C2,C$2:C$3,0)))

and C6
=IF(COUNTA($A$6:$A6)<=COUNTA($B$2:$C$3)/2,$B$1,$C$1)
and copied down

This results in:

Bob taska
Alice taska
Ted taskb
Bob taskb


Regards
Peter
"Don" wrote:

"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