Forum Discussion

SJHALANI's avatar
SJHALANI
Helper I
3 years ago
Solved

Rows to Columns

Hi, I have a table which is the below format: PO# Other columns SOW Type aa xx a aa xx b aa xx c bb xx a bb xx b   I want to have only 1 unique row per PO. The in...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi SJHALANI 

     

    You can transform the table with below steps in Power Query. 

    First add a custom column with value "Yes".

    Then select "SOW Type" column, use "Pivot Column" feature, select the earlier "Custom" column as Values Column and use "Don't Aggregate". 

    Finally select a,b,c columns, replace null with "No" in these columns. 

    You will get the result you want. 

     

    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 SJHALANI 

 

You can transform the table with below steps in Power Query. 

First add a custom column with value "Yes".

Then select "SOW Type" column, use "Pivot Column" feature, select the earlier "Custom" column as Values Column and use "Don't Aggregate". 

Finally select a,b,c columns, replace null with "No" in these columns. 

You will get the result you want. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

 

  • SJHALANI's avatar
    SJHALANI
    Helper I
    3 years ago

    Hi,

    Thanks for the response. The only thing is when I am trying to apply the Pivot step above, it gives the below error. Would you know reason for this/how to resolve this?

    Don't get confused with the "TypeOfDocument" colm, it's the same as "SOW Type" column.
    TIA!