Repeat Table 2 for each row of Table 1

[ajaysomasi]

Hi all

I need a help here.. I have a Table 1 with n rows (extracted from power query) and also Table 2 extracted from power query, placed in 2 tabs in Excel.. I require to place a new table in the 3rd tab..

The new table should be able to place 2nd table for each row of first table.. Below is an example, simplified with 2x2 table grids.. In reality, my tables are quite big, hence looking to do this in Power Query.. Request you to please advise.. Please note, there is no existing relationship between input tables (may be we need to bring in a variable to relate them??)..

Table 1 (simplified to 2x2 table):

Col A	Col B
A1	B1
A2	B2

Table 2 (simplified to 2x2 table):

Col C	Col D
C1	D1
C2	D2

Table 3 (Output):

Col A	Col B	Col C	Col D
A1	B1	C1	D1
A1	B1	C2	D2
A2	B2	C1	D1
A2	B2	C2	D2

 

[JGordon11]

Note: none of the tblx2 column names can be identical to any tblx1 names

let
    tbl1 = Excel.CurrentWorkbook(){[Name="tblx1"]}[Content],
    tbl2 = Excel.CurrentWorkbook(){[Name="tblx2"]}[Content],
    tbl = Table.AddColumn(tbl1,"all", each tbl2),
    tcn = Table.ColumnNames(tbl2),
    Result = Table.ExpandTableColumn(tbl, "all", tcn, tcn)
in
    Result

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	tblx1			tblx2			query output
2
3	Column1	Column2		Column3	Column4		Column1	Column2	Column3	Column4
4	A1	B1		C1	D1		A1	B1	C1	D1
5	A2	B2		C2	D2		A1	B1	C2	D2
6							A2	B2	C1	D1
7							A2	B2	C2	D2
8
Sheet10