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(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),2)),””,CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),2)))向下向右仿制
满是数组公式，光标要放在公式修改栏的公式中恣意方位，按下Ctrl+Sshift+Enter三键，公式才能收效。
B11:J13单元格要设置为主动换行成果才干分行显现。