Create a second column with the same all values from the first one by each values of the first

[Anonymous]

Hello community, I'm trying to create a table with a list of products and by each element of the list create a copy of the list in a second column to count how many times the products are bought together.

I got something like this:

Product ID	Product
1	Coke
2	Gum
3	Chips
4	Water
5	Cookies
6	Candy

I would like to get something like this:

Product A	Product B
Coke	Coke
Coke	Gum
Coke	Chips
Coke	Water
Coke	Cookies
Coke	Candy
Gum	Coke
Gum	Gum
Gum	Chips
Gum	Water
Gum	Cookies
Gum	Candy
Chips	Coke
Chips	Gum
Chips	Chips
Chips	Water
Chips	Cookies
Chips	Candy
Water	Coke
Water	Gum
Water	Chips
Water	Water
Water	Cookies
Water	Candy
Cookies	Coke
Cookies	Gum
Cookies	Chips
Cookies	Water
Cookies	Cookies
Cookies	Candy
Candy	Coke
Candy	Gum
Candy	Chips
Candy	Water
Candy	Cookies
Candy	Candy

Thanks for reading!

[gooranga1]

Hi @Anonymous 

1. Go to Edit Queries
2. Create a new column in your table in Edit Queries which just equals the number 1.
3. Create a copy of the table
4. Merge Queries as New joining on the the custom column of 1. Selct Full Outer (all rows from both) as the Join Kind
5. Expand Columns and you will get the below.

pbix linked;

pbix

[Anonymous · Accepted solution]

In Power Query:

Add a custom column that just = 1

Merge the table with itself on that column, using full outer.

Expand the new column 

Then remove all the columns you do not want

Set date types

Final Table: