J
JPreeshl
This is for winners of a hole in golf. I have a list of 48 names in column a.
I pull out a possible 18 winners in another column. There is very seldom all
18 winners so there is blank rows in between the winners. I would like to
just pull out the winners and put them together without missing rows.
column
a b
jeff jeff
jay " "
kevin kevin
tom tom
jim " "
I would like another column to just show the winners jeff, kevin, tom.
The names and amount of winners will be different for every round.
I pull out a possible 18 winners in another column. There is very seldom all
18 winners so there is blank rows in between the winners. I would like to
just pull out the winners and put them together without missing rows.
column
a b
jeff jeff
jay " "
kevin kevin
tom tom
jim " "
I would like another column to just show the winners jeff, kevin, tom.
The names and amount of winners will be different for every round.