Query function bringing blank value where it should be a Not Set value-CodePudding

I am trying to query data from another tab but when i use the query formula it brings blank values and in the original table has a Not Set value. How can I make it to bring the original value?

This is an example sheet from the image

Example Sheet

CodePudding user response：

Try making the optional header parameter 1:

=QUERY(A1:A,"select *",1)

It looks like QUERY is getting confused and is thinking that the 'Not Sets' are part of the header and is concatenating them.

CodePudding user response：

use:

=QUERY({A1:A}, "where Col1 is not null", 1)