Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
4 years ago
Solved

query editor group by rows - text data

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 t...
Need Help
  • Matt22365's avatar
    Matt22365
    4 years ago

    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

Matt22365's avatar
Matt22365
Resolver III
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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