排序 成單元格 (11448)

F2:O5=TRIM(MID(SUBSTITUTE($D2,",",REPT(" ",99)),COLUMN(A1)*99-98,99))

F9:O12 {=IF(F2="","",IF(COLUMN(A1)=1,"",",")&INDEX($F2:$O2,RIGHT(SMALL(TEXT(MMULT({1,1},1-ISERR(-MID($F2:$O2,{1;2},1))),"0;;9")*10^8+IFERROR(MID($F2:$O2,MMULT({1,1},N(ISERR(-MID($F2:$O2,{1;2},1))))+1,9)*1,999)*10^5+COLUMN($A:$J),COLUMN(A1)),5))&G9)