非空白格 轉員工姓名 (11526)

C24{=INDEX($2:$2,SMALL(IF(VLOOKUP(D$23,D:I,COLUMN(B:F),)<>"",COLUMN(E:I),99),ROW(A1)))&""

F24:H28{=OFFSET($D$1,COLUMN(A1),SMALL(IF(VLOOKUP($D$23,$D:$I,COLUMN($B:$F),)<>"",COLUMN($A:$E),99),ROW(A1)))&""