自用的二维表转一维表的通用公式

=LET(hqy,A4:C9,lqy,D1:G3,sjqy,D4:G9,lb,LAMBDA(a,b,IF(b="h",TRANSPOSE(SCAN("",TRANSPOSE(a),LAMBDA(x,y,IF(y="",x,y)))),SCAN("",a,L...