Forum Discussion

dianate12's avatar
dianate12
Frequent Visitor
3 years ago
Solved

splitting rows into column

How to convert this in power query , if I have duplicte name with values , the values should be populated into next columns , how to achieve this in power query. (From green to red in image)
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    dianate12 , Create a sub-index in power query and then append that with "Value" and use that in the Matrix column

     

    Power BI and Power Query- Sub Category Rank and Index: https://youtu.be/tMBviW4-s4A

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

dianate12 , Create a sub-index in power query and then append that with "Value" and use that in the Matrix column

 

Power BI and Power Query- Sub Category Rank and Index: https://youtu.be/tMBviW4-s4A