合併下行空白數據 (11469)

C2:C11=B2&IF(A3,"",C3)

I2:I7 {=IFERROR(INDEX(A:A,SMALL(IF(A$2:A$16>0,ROW($2:$16)),ROW(A1))),"")

J2:J7=IF(I2="","",VLOOKUP(I2,A:C,3,))