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:
I would like to get something like this:
Thanks for reading!
Go to 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
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!