I have created a query and am trying to perform normalized Excel export. Currently, Excel export does not show repeating rows for the same data. I need to have it normalized so that each all columns of each row are populated even if cell data is repeating. Example is below. Please advise if there is a way to design the query so that data is exported in normalized manner. Thank you!
Hi,
in fact that is pretty easy: select the respective query item (e.g. org-unit in your case) and press space. You'll then get a pop-up window, in which you can "unmerge" cells by ticking the respective box. Alternatively, you can change the formula of the query item=QUERY_ITEM("YOUR VALUE";TRUE;TRUE) to =QUERY_ITEM("YOUR VALUE";TRUE;FALSE)
Hope this helps.
Best,
Veronika
I am no expert, but I have attached a print-screen of an example of a very simple query that I have where I changed the "merge results" setting on the data field that I was outputting, and this achieved what you are looking for.
If the "merge results" is set to "Yes" then the data value will only be displayed once down the multiple rows that it occurs on whereas if you set it to "No" the data value is repeated on EVERY row.
Hope this helps.
Hi,
in fact that is pretty easy: select the respective query item (e.g. org-unit in your case) and press space. You'll then get a pop-up window, in which you can "unmerge" cells by ticking the respective box. Alternatively, you can change the formula of the query item=QUERY_ITEM("YOUR VALUE";TRUE;TRUE) to =QUERY_ITEM("YOUR VALUE";TRUE;FALSE)
Hope this helps.
Best,
Veronika
Oh, those shortcut keys to get to do the same thing. Awesome.
Thanks Veronika
Hi Veronika,
It worked for my use case. Thank you for this solution. Cheers!