Cartesian Joins by rows with the same ID

[Smogu]

Hello,

I have table like this:

ID	Word
ID1	A
ID1	B
ID2	C
ID2	D

I need to do in PowerQuery Cartesian Joins by rows with the same ID:

ID	Word	Word_1
ID1	A	A
ID1	A	B
ID1	B	A
ID1	B	B
ID2	C	C
ID2	C	D
ID2	D	C
ID2	D	D

Thanks to suggestions.

 

[Bill Szysz]

let
    Source = Excel.CurrentWorkbook(){[Name="YourTableName"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"ID"}, {{"tbl", (x) => Table.AddColumn( x, "Word_1", each x[Word]), type table}}),
    #"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"ID"}),
    #"Expanded {0}" = Table.ExpandTableColumn(#"Removed Columns", "tbl", {"ID", "Word", "Word_1"}, {"ID", "Word", "Word_1"}),
    #"Expanded {0}1" = Table.ExpandListColumn(#"Expanded {0}", "Word_1")
in
    #"Expanded {0}1"

Regards