Forum Discussion
Solved
Unpivot Multiple Columns - Desktop
**total noob alert* Is there a to unpivot multiple data in PBI desktop? I have datasource = Excel which is has an unusable data structure. Table headers are shown transposed below: Im looki...
Hi bigdee008
Please check all the applied steps in Query Editor.The last step fill down can be used for other columns you need.
Regards,
Cherie
I went ahead and took a stab at this. Here's the final output of what I did:
Not entirely sure if that is what you are looking for ( or maybe more of a step in the correct direction). If I understand you correctly, the next step would be renaming the Current Head with the New Header?
Thanks a lot Nick and Greg, below screengrab shows the row 1 or my actual data set. Maybe that will shed more light on what im trying to accomplish.
I came across the EXACT same thing im trying to accomplish here in the link, however, im not sure how to modify the query utilized there: