字母A 往下聚非字母A (10498)

B2=IFERROR(IF(A2="A",LEFT(PHONETIC(A2:A99),MATCH(A2,A3:A99,)),""),PHONETIC(A2:A99))

另解=REPT(PHONETIC(OFFSET(A2,,,MODE((1-EXACT(A3:A666,"A")-(A3:A666=""))*{1,2}%+ROW($1:$664)))),EXACT(A2,"A"))