Help transforming table from single rows into multiple values

[wyndlpoons]

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	11/30/2022	12/2/2022	12/3/2022
Person Two	11/28/2022	11/30/2022	12/1/2022

...and make it look like this one?

Name	Date
Person One	11/30/2022
Person One	12/2/2022
Person One	12/3/2022
Person Two	11/28/2022
Person Two	11/30/2022
Person Two	12/1/2022

I've found some solutions that almost work, but can't quite figure out how to get there. 

[Anonymous · Accepted solution]

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]

Hi @wyndlpoons 

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

[wyndlpoons]

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