AG 下拉 {=IF(ROW(A1)>PRODUCT(LEN(AE$1:AE$3)-LEN(SUBSTITUTE(AE$1:AE$3,",",))+1),"",TRIM(MID(SUBSTITUTE(AE$1,",",REPT(" ",9)),(INT((ROW(A1)-1)/PRODUCT(LEN(AE$2:AE$3)-LEN(SUBSTITUTE(AE$2:AE$3,",",))+1))+1)*9-8,9))&","&TRIM(MID(SUBSTITUTE(AE$2,",",REPT(" ",9)),(MOD(INT((ROW(A1)-1)/(LEN(AE$3)-LEN(SUBSTITUTE(AE$3,",",))+1)),LEN(AE$2)-LEN(SUBSTITUTE(AE$2,",",))+1)+1)*9-8,9))&","&TRIM(MID(SUBSTITUTE(AE$3,",",REPT(" ",9)),(MOD(ROW(A1)-1,LEN(AE$3)-LEN(SUBSTITUTE(AE$3,",",))+1)+1)*9-8,9)))
留言
張貼留言