Forum Discussion
Create a custom table duplicating rows from another table based on the other table's headers
Hi, I'm asking for help creating a custom table which creates multiple rows out of each original row in my PowerBI dataset. Please excuse me if this has already been answered. The scenario: I...
Anonymous this can be easily achieved using the "Unpivot" transformation in Power Query.
After importing your table, select the "Customer" column, and from the Transform tab, select "Unpivot Columns" >> "Unpivot Other Columns".
Then, filter the "Value" column to keep only "Y", and finally, remove the Value column.
Anonymous this can be easily achieved using the "Unpivot" transformation in Power Query.
After importing your table, select the "Customer" column, and from the Transform tab, select "Unpivot Columns" >> "Unpivot Other Columns".
Then, filter the "Value" column to keep only "Y", and finally, remove the Value column.
Amazing, this is exactly what I needed. Thank you very much!