Search code examples
google-sheetsgoogle-docs

how to union multiple sheets in Google Sheet

I have multiple sheets with the same structure and number of columns. they are:

  • putri
  • devi
  • dewi

I want to UNION them all into one sheet. I tried the following formula

=query({putri!A2:K,devi!A2:K},"Select *") and it shows as follow:

enter image description here

which i expect as follow: enter image description here

how do I resolve this?

Solution

  • You may try:

    =query(vstack(putri!A2:K,devi!A2:K,dewi!A2:K),"where Col1 is not null")