Forum Discussion
Create a second column with the same all values from the first one by each values of the first
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 toge...
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:
gooranga1
Power Participant
Power ParticipantHi Anonymous
- Go to Edit Queries
- Create a new column in your table in Edit Queries which just equals the number 1.
- Create a copy of the table
- Merge Queries as New joining on the the custom column of 1. Selct Full Outer (all rows from both) as the Join Kind
- Expand Columns and you will get the below.
pbix linked;