Excel数据批量转置(同一日期多行数据,转置成一行)有什么快捷的方法?答: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),"",INDEX(B:B,INT(SMALL(E:E,ROW(A1))/100)))下拉 5、i2=IF(ROW...