Forum Discussion

RobHaigh's avatar
RobHaigh
New Member
2 years ago
Solved

How to combine multiple rows in to columns

Trying to get my head round Dynamics 365 Finance and Operations and Power BI. Finance and Operations holds product data and each product can have multiple attributes against it. Due to the way Fina...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi RobHaigh ,

     

    In Power Query, select your [AttributeName] column, go to the Transform tab > Pivot Column and set up the dialog like this:

     

    ...to get this output:

     

     

    Pete

RobHaigh's avatar
RobHaigh
New Member
2 years ago

Pete, Many thanks, saved me a ton of head scratching 🙂