Answer the question
In order to leave comments, you need to log in
How to remove empty fields in Google spreadsheets when importing?
Hello. When importing from another document or complex queries, an empty line is inserted as in the photo. How to get rid of it? Above this empty line is the formula itself. Pivot tables are the same nonsense. This does not happen if you explicitly specify a range in an import or query formula. But I need to specify the range from beginning to end, that is, I specify it as Sheet1! A: B.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question