Forum Discussion
Columns to Rows Data Modelling Challenge
Hi - I think I'm close but stuck on final hurdle. I have used a combination of UnPivot, and Re-Pivot to get me there. I have a data set that looks like this (3 related fields for Product, Unit P...
Anonymous
Attaching your Excel file as well. Please see the steps from Query Editor
Anonymous
Hopefully no issues. But let me know if it gives error
Zubair_Muhammad - Just to confirm, I have adapted this solution to my specific use case and it is working very well... there are also no issues with refreshes.
Thank you so much for your help!
Regards
Gerard