C2:F9=IF($B2=1,IF(COLUMN(A1)>-LOOKUP(1,-MATCH(1=1,$B3:$B9=1,{1,0})),"",OFFSET($A1,COLUMN(A1),)&" "&D2),"")
K2:N9{=IF($B2=1,INDEX($I:$I,RIGHT(SMALL(IF(ROW(2:$10)<=-LOOKUP(1,-MATCH(1=1,$B3:$B$10=1,{1,0}))+ROW(A1),$J2:$J$10/1%+ROW(2:$9),9999),COLUMN(A1)),2))&""&" "&L2,"")
留言
張貼留言