Conditional Merge Multiple Queries

[Anonymous]

Hello,

I have two queries that need merged based on a value in a cell.

I need the rows in Query B to be inserted under the row in Query A when a specific cell matches.

For example in Query A in a column I have the value 123, next row 456, third row 789. In Query B I have the same values but different columns. Can the queries be combined in which the row from Query A is row 1, then the row from query B that matches is row 2. Then third line is the second value in Query A with the second value in Query B in row four?

For example below:

Second column matches in both queries. I need Query A as the first record and then Query B that has the same corresponding second column value to be the next line and so on.

Query A

Query B

Thanks so much.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Pls refer the below:

base table:

Outputresult:

You could download my pbix file to learn the details operations.

Best Regards

Lucien