Forum Discussion
Cross tab table
I need help changing a table from multiple rows to a grouped by and then into a single row see example.
T
Hi cisyncllc
Pivot column feature exactly does what you want. Pivot columns - Power Query | Microsoft Docs
Select the "groupdesc" column and click on Pivot Column. In the pop-up "Pivot Column" window, select "Itemdesc" for Values column and expand "Advanced options" and select "Don't Aggregate" for Aggregate Value Function.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
Hi cisyncllc
Pivot column feature exactly does what you want. Pivot columns - Power Query | Microsoft Docs
Select the "groupdesc" column and click on Pivot Column. In the pop-up "Pivot Column" window, select "Itemdesc" for Values column and expand "Advanced options" and select "Don't Aggregate" for Aggregate Value Function.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.I need to accomplish this in Power Query so I can use the table in other queries and merges
Thank you for any assistance.
=Table.Combine(Table.Group(PreviousStepName,"ID",{"n",each #table({"ID"}&[groupdesc],{{[ID]{0}}&[itemdesc]})})[n])
