Forum Discussion
Solved
PowerQuery Unpivot o Pivot
[ Spoiler ] I have this case where the data is received in this structure per year and 12 months in every column. As I do in PowerQuery so that it is in a structure which I can model for the reports...
Hi mrbajana ,
I've created a handy function for a part of what Michiel has described here: https://www.thebiccountant.com/2017/06/19/unpivot-by-number-of-columns-and-rows-in-powerbi-and-powerquery-in-excel/
After the unpivot, you simply have to select the column with the desired column names and pivot (back) on them.
Hi mrbajana ,
I've created a handy function for a part of what Michiel has described here: https://www.thebiccountant.com/2017/06/19/unpivot-by-number-of-columns-and-rows-in-powerbi-and-powerquery-in-excel/
After the unpivot, you simply have to select the column with the desired column names and pivot (back) on them.
PowerQuery is Magic thank you very much for your help!!!