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
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")