wps怎么单个单元格显示多个查询结果？

你试试这个公式：

=CONCAT(UNIQUE(IF(MMULT(TRANSPOSE(N(IF((A5:A11=J15)*(I5:I11=J16),E5:E11,0)={"G1","G2","G3","G6","G7","G8","G9","G10","G11","G12","G13"})),ROW(5:11)^0),{"1号机";"2号机";"2号机";"4号机";"4号机";"5号机";"5号机";"6号机";"6号机";"自动线";"自动线"},"")))

数组公式，数组三键输入。