空格分區 同區聚集 (14166)

(2007版) E2:H10{=INDEX($B:$B,SMALL(IF((COUNTIF(OFFSET($B$2,,,ROW($1:$23))," ")+1=ROW(A1))*($B$2:$B$24<>" "),ROW($2:$24),99),COLUMN(A1)))&""&F2

J2:J10(有 1空白格才可)=TRIM(MID(SUBSTITUTE(PHONETIC(B$2:B$24)," ",REPT(" ",99)),ROW(A1)*99-98,99))