excel表格多行多列怎么变成一列数据答:E2=IF(ROW(A1)>COUNTA($A$2:$D$9),"",INDIRECT(TEXT(SMALL(IF($A$2:$D$9<>"",ROW($A$2:$D$9)*100+COLUMN($A$2:$D$9),99^9),ROW(A1)),"r0c00"),))F2=IF(ROW(A1)>COUNTA($A$2:$D$9),"",INDEX($A$1:$D$9,MOD(SMALL(IF($A$2:$D$9<>"",ROW($A$2:...
excel 中 将多行多列 ,汇 为一列的方法答:E2=INDEX($A:$D,INT(SMALL(IF($A$2:$D$12<>"",ROW($A$2:$D$12)+COLUMN($A$2:$D$12)/100,4^8),ROW(E1))),MOD(SMALL(IF($A$2:$D$12<>"",ROW($A$2:$D$12)+COLUMN($A$2:$D$12)/100,4^8),ROW(E1)),1)*100)&""F2=IF(ROW(E1)>COUNTA($A$2:$D$12),...