=QUERY('BETA - Orders'!$D:$U,"Select Q,K where D='"& I228 &"' and Q is not null and D is not null",0)

I would like to display the result in one column only instead of two rows. The result of the query above is

What I would like to accomplish is

CodePudding user response：

try:

=QUERY(FLATTEN(QUERY('BETA - Orders'!$D:$U,
 "select Q,K 
  where D='"&I228&"' 
    and Q is not null 
    and D is not null", 0)), 
 "where Col1 is not null", 0)