Answer the question
In order to leave comments, you need to log in
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'
")
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question