excel表格订单号和快递单号在同一列。怎么把它2个分列在同一行?_百 ...答:A11=INDEX(A:A,MIN(IF(COUNTIF($A$10:$A10,$A$1:$A$7),4^8,ROW($A$1:$A$7)))&""向下复制B11=INDEX(B:B,SMALL(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),1))&IF(INDEX(B:B,SMALL(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),1))=INDEX(B:B,SMALL(...