converting rows into column in powerquery

Hi  MSuser5 ,

Here are the steps you can follow：

1. Go to Power Query – check [IN], [Out] – Unpivot Columns.

Result:

2. Transform – Group  -- [ID] – Operation：All Rows.

3. Add Column – Custom Column – Enter the following code.

Table.AddIndexColumn([Count],"Rank",1,1)

4. Selected [Count] – Remove.

5. Expand [Custom] - Do not select column [ID] - OK.

6. Select the three columns [Custom.Process], [Custom.Attribute], [Custom.Rank] -- right mouse button – in the Merge Column interface – to set the information at the yellow label.

7. Select [Merged] -- Transform – Pivot Column.

Value Column  --  [Custom.Value].

Advanced options – Don’t Aggregate.

8. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly