0

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

Improve this question
1
  • Your question can be greatly improved if you add a table to the question. Tables are a better alternative than spreadsheets to show your data structure. If you share spreadsheets, make sure to also add images of your sheet to avoid closure of your question, as questions here must be self contained. Your email address can also be accessed by the public, when you share Google files. Commented Jul 5, 2022 at 11:37

2 Answers 2

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

True, it was missing to specify the header, thanks a lot, and now what is happening is that it brings blank values, how could I make it to bring the not set value in the query as in the original?
Try =arrayformula(query(to_text(A1:A),"select *",1)) - this is probably happening because QUERY only accepts the majority data type in a column and you have more dates than 'Not sets'
1

use:

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

1 Comment

This is the magic "is not null" - I tried for ages with Col1<>''......

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.