C2:G13{=IFERROR(TRIM(MID(SUBSTITUTE(INDEX($A:$A,SMALL(IF(LEN($A$2:$A$5)-LEN(SUBSTITUTE($A$2:$A$5,",",))+1>=COLUMN($A:$I),ROW($2:$5)),ROW(A1))),",",REPT(" ",19)),(RIGHT(SMALL(IF(LEN($A$2:$A$5)-LEN(SUBSTITUTE($A$2:$A$5,",",))+1>=COLUMN($A:$I),ROW($2:$5)/1%+COLUMN($A:$I)),ROW(A1)))-COLUMN(A1)=0)*COLUMN(A1)*19-18,19)),"")
留言
張貼留言