Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have the following data
Respondee | Response Time | Month | Project 1 | Days 1 | Project 2 | Days 2 | Project 3 | Days 3 |
mickey mouse | 08/02/2023 15:42 | Jan-23 | Researching Things | 6.5 | Buying Things | 6.5 | Making Things | 8
|
But I need it in the following format:
Respondee | Response Time | Month | Project | Days |
mickey mouse | 08/02/2023 15:42 | Jan-23 | Researching Things | 6.5 |
mickey mouse | 08/02/2023 15:42 | Jan-23 | Buying Things | 6.5 |
mickey mouse | 08/02/2023 15:42 | Jan-23 | Making Things | 8 |
Is this possible in Power Query? To Repeat my first 3 "index" columns, but to "pivot" the other columns next to them?
Many thanks 🙂
Solved! Go to Solution.
Yes, it's possible.
Select 1st 3 columns and UNpivot Other columns.
Split the attribute column (on non-digit to digit).
Pivot the Attribute1 column using Value in Values and 'Do not aggregate' in Advanced section
Yes, it's possible.
Select 1st 3 columns and UNpivot Other columns.
Split the attribute column (on non-digit to digit).
Pivot the Attribute1 column using Value in Values and 'Do not aggregate' in Advanced section
That's super helpful, thank you HotChilli. I'm just learning how useful PQ is.