Power Query - Join And Fill Rows

[lager1001]

I need to make the following two tables:

T1 T2

ABC 123
DEF 456
GHI 789

Do the following:

ABC 123
ABC 456
ABC 789
DEF 123
DEF 456
DEF 789
GHI 123
GHI 456
GHI 789

I may be over thinking it or maybe not Googling the right terminology to do this.

 

[sandy666]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Each = Table.AddColumn(Source, "T2", each Table2),
    Expand = Table.ExpandTableColumn(Each, "T2", {"T2"}, {"T2"})
in
    Expand

T1		T2		T1	T2
ABC		123		ABC	123
DEF		456		ABC	456
GHI		789		ABC	789
				DEF	123
				DEF	456
				DEF	789
				GHI	123
				GHI	456
				GHI	789

 

[lager1001]

You saved the day. Thank you so much sandy666.

 

[lager1001]

I spoke too soon. I guess I should have clarified, the tables are each their own table in Power Query. Not just columns in the same table.

 

[sandy666]

as you see in post#2 there are two tables (blue) with single column each, so ?

use XL2BB to show what you have and what you want

 

[sandy666]

like this?
but imho it doesn't make sense

T1		T2		T1		T2
ABC		123		ABC		123
DEF		456		ABC		456
GHI		789		ABC		789
				DEF		123
				DEF		456
				DEF		789
				GHI		123
				GHI		456
				GHI		789

 

[lager1001]

Got it! Thanks again!

 

[sandy666]

your answer is enigmatic ?
but I understand you want to see M-code, so ...

base table (as connection)

// cartesian
let
    tbl2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    tbl1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"each" = Table.AddColumn(tbl1, "custom", each tbl2),
    expand = Table.ExpandTableColumn(#"each", "custom", {"T2"}, {"T2"})
in
    expand

first reference table

// cartesianT1
let
    Source = cartesian,
    TSC = Table.SelectColumns(Source,{"T1"})
in
    TSC

second reference table

// cartesianT2
let
    Source = cartesian,
    TSC = Table.SelectColumns(Source,{"T2"})
in
    TSC