"Please advise on how to correctly input the formulas to get the desired result as shown in the picture. Task:


  1. Лист1 (used as a database) where information is entered and then distributed to ЯБЛОКИ,ГРУШИ,СЛИВЫ.
  2. On Sheets (ЯБЛОКИ,ГРУШИ,СЛИВЫ) I applied the ARRAYFORMULA function to import images from the "PNG" sheet, but the import formula from Лист1 was immediately disrupted. Here is the desired version on the "ГЛАВНЫЙ" sheet." enter image description here

1 Answer 1


The query() function returns images as null values. Use filter() instead, like this:

  data; vstack('ЯБЛОКИ'!A2:G; 'ГРУШИ'!A2:G; 'СЛИВЫ'!A2:G); 
  filter(data; len(choosecols(data; 1)) + len(choosecols(data; 3))) 

See let(), vstack(), filter() and choosecols().


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.