日期 拆多行緊接 (10025)

A10:D10下拉{=INDEX(A:A,SMALL(IF(LEN($E$2:$E$6)-LEN(SUBSTITUTE($E$2:$E$6,".",))+1>=COLUMN($A:$Z),ROW($2:$6),99),ROW(A1)))&""

E10下拉=IF(A10="","",TRIM(MID(SUBSTITUTE(VLOOKUP(A10,A:E,5,),".",REPT(" ",99)),COUNTIF(A$10:A10,A10)*99-98,99)))