Excel中如何将ABCDE列内容数据变为第一行ABE三列,第二行ACE,第三行AD...答:在另三列里用indirect做公式转换,根据当前行号计算应该指向的原单元格索引 G1:=INDIRECT("a"&(ROUNDDOWN((ROW()-1)/3,0)+1))H1:=INDIRECT((IF(MOD(ROW(),3)=1,"b",IF(MOD(ROW(),3)=2,"c","d")))&(ROUNDDOWN((ROW()-1)/3,0)+1))I1:=INDIRECT("e"&(ROUNDDOWN((ROW(...