excel表格订单号和快递单号在同一列。怎样把它2个排列在同一行？

　　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单*格要设置为主动换行成果才干分行显现。