EXCEL一列值对应另一列多值,需拆分成每行一一对应?答:A3单元格输入公式=IF(COLUMN()=1,IFERROR(INDEX($A$1,SMALL(IF(LEN($B$1)-LEN(SUBSTITUTE($B$1,",",))+1>=COLUMN($A:$AZ),ROW($1:$1)),ROW(A1))),""),TRIM(MID(SUBSTITUTE($B$1,",",REPT(" ",100)),ROW(A1)*100-99,100)))数组公式,需按Ctrl+Shift+Enter三键结束...