With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, June 10, 2018
yogi_query a column of single cells and output it to a column of merged cells
How do I query a column of single cells and output it to a column of merged cells?
I have am trying to import some data into merged cells (3 cell height). I need the merged cells because they are effectively labels for 3 rows. The problem I am having is that the range being queried is not merged so some data is being "hidden" in the merged cells; 1 cell appears and the other 2 are hidden by the merge.
My query is a standard =query(importrange("url","tab!range"),"select * where Col1 is not null")
I have been looking for about an hour but can't find anything of help. Is it possible to do what I am attempting?
Thanks in advance!
Edit: What I am hoping for is to have only one value per merged cell. So if A1:A3 and A4:A6 are merged cells, the data from the query would go into cells A1 and A4.