=INDIRECT(TEXT(SMALL(IF($A$1:$G$100<>"",COLUMN($A$1:$G$100)+ROW($A$1:$G$100)*10,655361),COLUMN(A1)),"!R0!C0"),0)&""数组公式,Ctrl+Shift+回车结束,向右填充。