Forum Discussion

cisyncllc's avatar
cisyncllc
Frequent Visitor
3 years ago
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    
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.