合併格連結字符 (9292)

C2下拉=IF(A2="",IF(A3="",B2&C3,B2),B2&C3)

格式化C2:C15=A2=""

D2=IF(A2="","",PHONETIC(OFFSET(B2,,,MODE((A3:B10="")+ROW($1:$8)))))

另解=IF(A2="","",PHONETIC(OFFSET(B2,,,-LOOKUP(9,-MATCH(1=1,A3:A$17<>"",{1,0})))))