B2=TRIM(MID(SUBSTITUTE(LOOKUP("嫻",A$2:A2),"、",REPT(" ",29)),(MOD(ROW(A1)-1,2)+1)*29-28,29))
E2{=IFERROR(TRIM(MID(SUBSTITUTE(T(OFFSET(D$1,SMALL(IF(LEN(D$2:D$7)-LEN(SUBSTITUTE(D$2:D$7,"、",))+1>=COLUMN(A:I),ROW($1:$6)),ROW(A1)),)),"、",REPT(" ",29)),RIGHT(SMALL(IF(LEN(D$2:D$7)-LEN(SUBSTITUTE(D$2:D$7,"、",))+1>=COLUMN(A:I),ROW($1:$6)/1%+COLUMN(A:I)),ROW(A1)))*29-28,29)),"")
H2=TRIM(MID(SUBSTITUTE(LOOKUP("嫻",G$2:G2),"、",REPT(" ",29)),(ROW()-LOOKUP(1,0/(G$2:G2>0),ROW($1:1)))*29-28,29))
留言
張貼留言