Hi Ad,

Delete the text from J9 (leave it blank), then put this array formula in J10 and fill it down the column as far as necessary. (After typing or pasting this formula into J10, you must press CTRL+SHIFT+ENTER, not just ENTER.) Also, change the references to $I$500 to a higher row number if your data goes further down than row 500.

=IF(I10="","",IF(J9<>"",J9,INDEX(INDIRECT("I"&ROW()&":I"&ROW()+MATCH(TRUE,I10:$I$500="",0)-2),MATCH(1,INDIRECT("F"&ROW()&":F"&ROW()+MATCH(TRUE,I10:$I$500="",0)),0))))

Hope that helps!