EXCEL将含有相同值的列转换为多行,不是简单行列转换, 转置,有数万行...答:假设数据在A1:A20中,D2中输入 =INDEX(A$1:A$20,MATCH(,COUNTIF(D$1:D1,A$1:A$20),))&""同时按下CTRL+SHIFT+回车,输入数组公式,下拉。E2中输入 =IF(COLUMN(A1)>COUNTIF($A$1:$A$20,$D2),"",INDEX($B$1:$B$20,SMALL(IF(COUNTIF($D2,$A$1:$A$20),ROW($1:$20)...