Cross tab table

[cisyncllc]

I need help changing a table from multiple rows to a grouped by and then into a single row see example.    

T

[wdx223_Daniel]

=Table.Combine(Table.Group(PreviousStepName,"ID",{"n",each #table({"ID"}&[groupdesc],{{[ID]{0}}&[itemdesc]})})[n])

[v-jingzhang · Accepted 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.

[cisyncllc]

I need to accomplish this in Power Query so I can use the table in other queries and merges

Thank you for any assistance.