Excel formula to fill empty cells in a column with a list from another column/table

Looking for an excel formula to auto fill only the empty cells of a column with data form another column/table.

The ordered list from table1 was created with the formula: '=IFERROR(INDEX($A$2:$A$11,SMALL(IF($B$2:$B$11="yes",ROW($A$2:$A$11),""),ROW()-1)-1,1),"")

Then I wanted to distribute the list in to the empty cells of a partially filled column in Table2. I tried using the formulas:

=IF(F2<>"",F2,C2)

=IF(F2<>"",F2,ROWS(C$2:C2))

=IF(J73<>"",J73,INDEX($C$73:$C$82,AGGREGATE(15,6,ROW($C$73:$C$82)-ROW($C$72)/($C$73:$C$82<>""),ROWS(C$73:C73))))

But none of them give me the expected outcome. (see attached image)

Any suggestions?
Thank you in advanced.

enter image description here

Solution 1:

1] In "yes list" C2, formula copied down :

=IF(F2="",INDEX(A$2:A$11,AGGREGATE(15,6,ROW(A$1:A$10)/(B$2:B$11="yes"),COUNTBLANK(F$2:F2))),"")

2] In "Result" H2, formula copied down :

=IF(F2="",C2,F2)

enter image description here