Forum Discussion
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 | 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.
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.
3 Replies
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.
Hi wyndlpoons
Have you tried Unpivot Columns ? If so, what was the result?
Yep, Unpivot Columns worked for me. Thanks for the help!
