Can you provide an example sheet to clarify the tables you want to merge and how you want the data portrayed?

You said you used an “array query” but I’m not clear on what you mean. A query produces an array. Have you tried an “array of queries”? This would look like this:

={(query(sheet1!A1:C3, “select *”));(query(sheet2!A1:C3, “select *”))}

I’m on mobile but you get the point. * would be replaced with your query. Depending on whether you us a ; or , to separate the queries within the array will determine whether the two queries are put together from top to bottom or from left to right.

EDIT:

Here is an example of merging 3 different sheets. You will have to adjust the queries and, of course, the sort is optional. The outer query is to remove blank rows from getting into the final output.

= SORT( QUERY( { (QUERY(Sheet1!A1:Z "select *") ; (QUERY(Sheet2!A1:Z "select *") ; (QUERY(Sheet3!A1:Z "select *") }, "select * where Col1 is not null"), 1, TRUE)

Can you provide an example sheet to clarify the tables you want to merge and how you want the data portrayed?

You said you used an “array query” but I’m not clear on what you mean. A query produces an array. Have you tried an “array of queries”? This would look like this:

={(query(sheet1!A1:C3, “select *”));(query(sheet2!A1:C3, “select *”))}

I’m on mobile but you get the point. * would be replaced with your query. Depending on whether you us a ; or , to separate the queries within the array will determine whether the two queries are put together from top to bottom or from left to right.

EDIT:

Here is an example of merging 3 different sheets. You will have to adjust the queries and, of course, the sort is optional. The outer query is to remove blank rows from getting into the final output.

= SORT( QUERY( { (QUERY(Sheet1!A1:Z, "select *") ; (QUERY(Sheet2!A1:Z, "select *") ; (QUERY(Sheet3!A1:Z, "select *") }, "select * where Col1 is not null"), 1, TRUE)

Can you provide an example sheet to clarify the tables you want to merge and how you want the data portrayed?

You said you used an “array query” but I’m not clear on what you mean. A query produces an array. Have you tried an “array of queries”? This would look like this:

={(query(sheet1!A1:C3, “select *”));(query(sheet2!A1:C3, “select *”))}

I’m on mobile but you get the point. * would be replaced with your query. Depending on whether you us a ; or , to separate the queries within the array will determine whether the two queries are put together from top to bottom or from left to right.

Can you provide an example sheet to clarify the tables you want to merge and how you want the data portrayed?

You said you used an “array query” but I’m not clear on what you mean. A query produces an array. Have you tried an “array of queries”? This would look like this:

={(query(sheet1!A1:C3, “select *”));(query(sheet2!A1:C3, “select *”))}

I’m on mobile but you get the point. * would be replaced with your query. Depending on whether you us a ; or , to separate the queries within the array will determine whether the two queries are put together from top to bottom or from left to right.

EDIT:

Here is an example of merging 3 different sheets. You will have to adjust the queries and, of course, the sort is optional. The outer query is to remove blank rows from getting into the final output.

= SORT( QUERY( { (QUERY(Sheet1!A1:Z "select *") ; (QUERY(Sheet2!A1:Z "select *") ; (QUERY(Sheet3!A1:Z "select *") }, "select * where Col1 is not null"), 1, TRUE)