Why doesn't Google Sheets QUERY return the contents of multiple columns?

D

D

daddy4gym2020-01-10 17:10:03

Google Sheets

daddy4gym, 2020-01-10 17:10:03

Why doesn't Google Sheets QUERY return the contents of multiple columns?

We have the contents of the row:

When this row is displayed using the QUERY function, only the values \u200b\u200bof "0" are displayed, for columns with the value "is" empty values are returned. Who faced this? - how to solve the problem?
Changing cell formats did not help (

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

Noir, 2020-01-10
@PolarBearGG

there is such, try through the filter it will work 100%

Similar questions

M

MoscowRoller2021-08-30 11:13:50

How to use the importxml formula to parse the price of a product? 1Reply

M

Mr.2020-06-14 14:33:07

How to put a formula in a drop down list? 1Reply

Z

Zakonoposlushniy2021-09-06 19:58:43

How to calculate the sum of several parameters? 1Reply

B

bmw_man8602020-06-19 14:25:33

How to calculate the value of the cell you are looking for using IF() or some other function that will iterate over the entire array range? 2Reply

A

Alina Shah2021-09-13 10:52:27

How do you turn a negative number into a positive one? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question