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

Question

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

Answer 1

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.