填滿數字前方格 (10805)

D2:H7=REPLACE(IF(COLUMN(A1)=1,$A$2,C2),MID(REPT($B2&",",5),COLUMN(A1)*2-1,1)*3-2,1,"■")

另解=SUBSTITUTE(IF(COLUMN(A1)=1,$A$2,C2),"□"&(0&MID($B2,COLUMN(A1)*2-1,1))*1,"■"&(0&MID($B2,COLUMN(A1)*2-1,1))*1)