N
N
netone2021-01-22 21:04:35
Google Sheets
netone, 2021-01-22 21:04:35

Why QUERY prints value in one line?

The formula is quite simple:

=query('выгрузка'!A1:D1000;"select C, K , L
WHERE C contains 'LK' 
and
C contains 'AND' 
")

The fact is that when you expand the specified range from A1: D1000 to E1000, for example, then 70% of the data starts to be displayed in the first line (even the data that did not pass the AND conditions), and the remaining 30% are already displayed as needed.

But if you do not go beyond a certain range, then up to this range everything is displayed as it should. How to solve it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2021-01-27
@netone

The question was solved by @mityayka1 in the comment Why does QUERY display a value in one line?
The essence of the solution is to use the third argument of QUERY to specify the number of rows for headers, i.e.
=QUERY(range; sql_query; 1)
this one is important1

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question