将一个格里的数据 ,换成多行 (10358)


D2{=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX(B:B,SMALL(IF(A$2:A$58>=COLUMN(A:I),ROW($2:$58)),ROW(A1))),",",),CHAR(10),REPT(" ",99)),RIGHT(SMALL(IF(A$2:A$58>=COLUMN(A:I),ROW($2:$58)/1%+COLUMN(A:I)),ROW(A1)))*99-98,99)),"")


留言