查找数据，条件和查找结果均分行显示

mengrs

=HSTACK(VSTACK(A1,SEQUENCE(COUNTA(C2:F7))),REDUCE(UNIQUE(B1:H1,1),B2:B7,LAMBDA(x,y,VSTACK(x,CHOOSE({1,2,3,4},y,TOCOL(OFFSET(y,,1,,4),1),OFFSET(y,,5),OFFSET(y,,6))))))

mengrs

=VSTACK(UNIQUE(A1:H1,1),CHOOSECOLS(LET(f,LAMBDA(x,TOCOL(IF(C2:F7>0,x,0/0),3)),GROUPBY(HSTACK(SEQUENCE(COUNTA(C2:F7)),f(B2:B7),f(G2:G7),f(H2:H7)),f(C2:F7),t,,0)),1,2,5,3,4))

gwjkkkkk

=SORT(DROP(REDUCE({"属性","姓名"},C2:F6,LAMBDA(x,y,IF(y<>"",VSTACK(x,HSTACK(INDEX(B:B,ROW(y)),y)),x))),1),1)

mengrs

=LET(a,HSTACK(TOCOL(IF(C2:F6>0,B2:B6,x),3),TOCOL(C2:F6,3)),SORTBY(a,MATCH(TAKE(a,,1),{"张三","李四","王麻子"},)))