Forum Discussion

wyndlpoons's avatar
wyndlpoons
Regular Visitor
3 years ago
Solved

Help transforming table from single rows into multiple values

Hi, I'm new to Power BI & Power Query and am running into a problem with a Power Query transformation. Is there a way to take a table like this... Name Column2 Column3 Column4 Person One...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi wyndlpoons ,

     

    As djurecic  said, unpivot column works.

    Here I made a sample file for your reference.

    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.

     

djurecic's avatar
djurecic
Super User
3 years ago

Hi wyndlpoons 

Have you tried Unpivot Columns ? If so, what was the result?

  • wyndlpoons's avatar
    wyndlpoons
    Regular Visitor
    3 years ago

    Yep, Unpivot Columns worked for me. Thanks for the help!