M
M
Maxim Valerievich2018-04-09 10:47:43
Google Sheets
Maxim Valerievich, 2018-04-09 10:47:43

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.
5acb1a972e948224356709.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question