员工的组次和工作依次找出 (10151)

I2{=IFERROR(INDEX(A$2:A$10&","&B$1:E$1,SMALL(IF(B$2:E$10=G$2,ROW($1:$9)),ROW(A1)),RIGHT(SMALL(IF(B$2:E$10=G$2,ROW($1:$9)/1%+COLUMN(A:D)),ROW(A1)))),"")