Forum Discussion
Pivot data in powerquery
Hi all, I got an excel sheet that looks like this and want to make it look like the one below using PowerQuery... I've tried the unpivot function but it behavious in a funny way. Help is appreci...
Unpivot would do the job if the Event names were in the column headers. With this data structure there will be no quick and easy solution I'm afraid
If the data is coming from an Excel pivot, why not just rearrange it in Excel?
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
I accept your post as a solution since i agree there isnt an easy way to make this work...however, one thing that just might work (but is not a good time investment) is to chop the table into several ones via DAX and then append the tables together...you're right, ill just do it through excel :)
Thanks,
Dat_Data
oh absolutely, you can also do it with PowerQuery/M, not only DAX, but I honestly don't think it's worth the time