Hi All,
I am a relative beginner with Power Query and the M language. I am running into issues using transform and unpivot: not sure they are even the right steps to be using. I have attached the excel file I am using as the data source, which also includes a tab titled desired structure, showing the ideal end result. I have also attached the pbix file for reference.
Many thanks, this is exactly what I was trying to do. Did you perform these steps using the PQ editor tool bar or by writing M? Just wondering for my own education.
I mix and match most of the time, so I did a bit of both…
But you can do this through the UI for 98% Except for calling the Source a second time and the #“Removed Top Rows” step in the Custom Column there’s no need to write any M