Power query merge tables any-to-any

Question

I new in MS Excel Power Query and i cant finde solution in google for this problem.

Join tables any-to-any row

Table1        Table2
+-----+       +-----+
|  A  |       |  1  |
|  B  |       |  2  |
+-----+       +-----+

Merge Table1 and Table2 to Table3

Table3
+-----+-----+
|  A  |  1  |
|  A  |  2  |
|  B  |  1  |
|  B  |  2  |
+-----+-----+

Answer 1

The link Hakan provided is great, so I'll just summarize it here.

---

Starting with your Table1, go to Add Column > Custom Colum and simply input Table2 as the formula.

Once that column is created, click the expand button and choose which columns from Table2 to expand.

This should result in the desired table.