Forum Discussion
Solved
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.
I need to accomplish this in Power Query so I can use the table in other queries and merges
Thank you for any assistance.