Excel数据批量转置(同一日期多行数据,转置成一行)有什么快捷的方法...答:加两个辅助列解决 1、d2=IF(A2="","",TEXT(A2,"m-d")&B2)下拉 2、e2=IF(D2="","",IF(D2<>D1,ROW()*100+COUNTIF(D2:D100,D2),""))下拉 3、g2=IF(ROW(A1)>COUNT(E:E),"",INDEX(A:A,INT(SMALL(E:E,ROW(A1))/100)))下拉 4、h2=IF(ROW(A1)>COUNT(E:E),"...