query editor group by rows - text data

Question

HiI hope someone can helpI have pulled some product data into query editor and pivoted to convert rows into columns to create an ingredient summary table which I can then use to create a column to use as a filter.Unfortunatly in the query editor i have now got multiple rows for each product depending on the ingredient column rather than 1 row which covers all ingredientsExample data belowIs there a way to group the row column so I get 1 row per product in query editor?Thanks for your helpProductIngredient 1Ingredient 2Ingredient 3Ingredient 4Ingredient 5Product 1Yes&nbsp;&nbsp;&nbsp;&nbsp;Product 1&nbsp;Yes&nbsp;&nbsp;&nbsp;Product 1&nbsp;&nbsp;Yes&nbsp;&nbsp;Product 1&nbsp;&nbsp;&nbsp;Yes&nbsp;

matt22365 · Accepted Answer

Thanks to anyone looking at this but Ive managed to find the answer
When I pivoted the data originally I did it with the product number as the Values column, instead I created a "Yes" column (a column which just said Yes in every line) and used that instead. Now I have athe table I needed

Thanks again

Product	Ingredient 1	Ingredient 2	Ingredient 3	Ingredient 4	Ingredient 5
Product 1	Yes
Product 1		Yes
Product 1			Yes
Product 1				Yes

Forum Discussion

query editor group by rows - text data

2 Replies

Related content

power query editor slow loading

Abnormal data display in Query Editor

Fabric & Azure Data User Group Program Requirements & Benefits

Tabular Editor - Calculation groups

Power Query Editor