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

1 Answerstry:

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

Answered by Tedinoz on November 18, 2021

6 Asked on September 15, 2020 by orschiro

1 Asked on August 30, 2020 by snazzybouche

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

1 Asked on July 31, 2020 by ianm

3 Asked on July 27, 2020 by davide-fiocco

0 Asked on July 24, 2020 by taylor

0 Asked on July 22, 2020 by sebastian-guajardo

Get help from others!

Recent Answers

- zkutch on A is greater than B by 25% then by what percentage B is less than A?
- Harish Chandra Rajpoot on A is greater than B by 25% then by what percentage B is less than A?
- Ethan Bolker on A is greater than B by 25% then by what percentage B is less than A?
- NeitherNor on How to segment a group of symmetric points
- Dominique on A is greater than B by 25% then by what percentage B is less than A?

Recent Questions

- How to segment a group of symmetric points
- Prove $D(A):= {win H^{2}(0, 2pi): w(0) = w(2pi), w^{‘}(0) = w^{‘}(2pi) }$ is dense in $L^{2}(0,2pi).$
- A is greater than B by 25% then by what percentage B is less than A?
- Show continuity of partial derivatives of piece-wise function
- For any two positive operator $a,b$ with norm $<1$ there is a $c$ such that $a,bleq c$ and $|c|<1$. Does this hold for $|a|=|b|=1$?

© 2021 InsideDarkWeb.com. All rights reserved.