重複顯示指定數 (14910)

E2{=INDEX(B:B,SMALL(IF(C$2:C$5>=COLUMN(A:Z),ROW($2:$5),9),ROW(A1)))&""

F2=IF(ROW(A1)>SUM(C:C),"",LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(C$1,,,ROW($1:$4))),B$2:B$5))