依序 按數字顯示籠名稱 (14306)

C3:C9=IFERROR(-LOOKUP(1,-RIGHT(A3,ROW($1:$9))),)

D3 下拉{=IFERROR(INDEX(LEFT(A$3:A$9,FIND(",",A$3:A$9&",")-1),MATCH(ROW(A1)-1,SUBTOTAL(9,OFFSET(C$2,,,ROW($1:$8))),)),"")

E3 下拉{=IF(ROW(A1)>SUM((0&MID(A$3:A$9,FIND(",",A$3:A$9&",")+1,9))*1),"",B3)