排列顛倒 (10141)

B2:H6{=IFERROR(IF(COLUMN(A1)=1,"","；")&INDEX(TRIM(MID(SUBSTITUTE($A2,"；",REPT(" ",99)),ROW($1:$9)*99-98,99)),TEXT(LEN($A2)-LEN(SUBSTITUTE($A2,"；",))-COLUMN(A1)+2,"0;;"))&C2,"")