Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need help changing a table from multiple rows to a grouped by and then into a single row see example.
T
Solved! Go to Solution.
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.
=Table.Combine(Table.Group(PreviousStepName,"ID",{"n",each #table({"ID"}&[groupdesc],{{[ID]{0}}&[itemdesc]})})[n])
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.