EXCEL中如何使多行多列项内容转成单行多列显示?答:假设你写的数据在A,B两列,行数为100行 则 C1单元格写入公式 =INDEX(A:A,SMALL(IF(MATCH(A$1:A$100&"",A$1:A$100&"",)=ROW($1:$100),ROW($1:$100),4^8),ROW(A1)))&""数组公式,按下SHIFT+CTRL+ENTER三键结束输入,下拉复制公式 D1单元写入公式 =INDEX($B:$B,SMALL(IF($A...
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:...