Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Matriz Power Query

Hello My doubt is that I am bringing some data like these: And in the power query editor I wanted to know if it is possible to transform them like this: It is very easy to do it in a...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You can pivot the column in the Power Query Editor.

    Here's the solution.

    1.Select the MES column and then click 'Pivot Column'.

     

    2.Set up as follows, then click OK.

     

     

    3.Here's the results.

     

    Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.

     

     

    Best Regards,

    Stephen Tao

     

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

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Fantastic, it was exactly what I needed. Thank you!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You can pivot the column in the Power Query Editor.

Here's the solution.

1.Select the MES column and then click 'Pivot Column'.

 

2.Set up as follows, then click OK.

 

 

3.Here's the results.

 

Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.

 

 

Best Regards,

Stephen Tao

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Fantastic, it was exactly what I needed. Thank you!