splitting rows into column

[dianate12]

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)

[amitchandak · Accepted solution]

@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