# Combine multiple tables into one table by matching the headers

I have two tables with the same header name. From this table I want to combine the data into one into one table by matching the header names.

The matching header names are "Link", "Review Date", "Review Author", "Review Remarks".

The logic to combine data with these conditions that I catch like this:

Search for column positions with a combination of REGEXMATCH:

=ArrayFormula(IF(REGEXMATCH('Multiple Table'!A2:Z2,"Link|ReviewsDate|ReviewsAuthor|ReviewsRemarks")=TRUE,COLUMN('Multiple Table'!A2:Z2),""))


Change the column into a range with ADDRESS formula :

=ArrayFormula(IF(REGEXMATCH('Multiple Table'!A2:Z2,"Link|ReviewsDate|ReviewsAuthor|ReviewsRemarks")=TRUE,ADDRESS(2,COLUMN('Multiple Table'!A2:Z2)),""))


I want the result from point 2 are A2:D, F2:H

Then to combine the data just enter the range A2:D and F2:D into the QUERY formula.

For the third step, I’m still confused about the formulation.

So I used a formula that wasn’t dynamic yet, like this:

= QUERY ({'Multiple Tables'! A2: D; 'Multiple Tables'! F2: H}, "SELECT Col1, Col2, Col3 WHERE Col1 <> ''")


Web Applications Asked by Lutfi Creativesys on November 18, 2021

try:
={query(A2:E10,"select *");query(F3:J10,"select *",0)}

Answered by Tedinoz on November 18, 2021

## Related Questions

### How can I insert a cross-reference to a figure in Google Docs?

6  Asked on September 15, 2020 by orschiro

### MS teams bot to add people to group chats

0  Asked on September 2, 2020 by user254126

### Can I view a specific commit to the gh-pages branch on github.io?

1  Asked on August 30, 2020 by snazzybouche

### How to set a cell is a formula equal to another cell?

1  Asked on August 20, 2020 by romulus-urakagi-tsai

1  Asked on August 2, 2020 by michael

### Tap to overwrite cell Google Sheets on Android?

1  Asked on July 31, 2020 by ianm

### How can I convert existing boolean cells into checkboxes in Google Sheets?

3  Asked on July 27, 2020 by davide-fiocco

### IF Statement works in Excel but not G Sheet?

0  Asked on July 24, 2020 by taylor

### How add 3d model to one map in a website?

0  Asked on July 22, 2020 by sebastian-guajardo