query editor group by rows - text data

[Matt22365]

Hi

I hope someone can help

I 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 ingredients

Example data below

Is there a way to group the row column so I get 1 row per product in query editor?

Thanks for your help

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

[Matt22365 · Accepted solution]

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

[v-yiruan-msft]

Hi @Matt22365 ,

Thanks for your feedback and sharing the solution. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards