Home > Software design >  How do I query multiple sheets in Google Sheet that result in a single master sheet?
How do I query multiple sheets in Google Sheet that result in a single master sheet?

Time:08-11

I have multiple sheets, in the example, Sheet1 and Sheet2 that I would like to query that results in a single Master sheet. see the enter image description here

Explanation

  • {} means Array
  • ; Stack ranges on top of eatch other
  • , to jion columns side by side "we did't need in this example"
  • "Select * Where Col1 is not null" Select all columns where column1 is not empty

Option 02 - without headers

=QUERY({ Sheet1!A2:C;Sheet2!A2:C }, "Select * Where Col1 is not null")

enter image description here

  • Related