I known that is a question already aswered but we loss time with it and future maintenance won’t be easy.
I use pivot to calculate name of dynamics column name.
With pivot, columns order are alphabetical. Why pivot don’t have option to choose order ? On this point Excel is much more powerful than EasyMorph.
I can no longer use pivot function and have to bypass its use.
In conclusion, the pivot function is unusable and the workaround is not flexible. As soon as you need an additional column, you have to make several changes.
And finally, the “rename columns” and “reorder columns” functions are too rigid. Everything is fixed and nothing is dynamic. We can’t use a value from a table or function.
Not alphabetical, just sorted left to right in ascending order.
How would you envision such an option?
It's not possible to maintain column order because column names before pivoting can come in a column in a different order in different groups. In one group it can be A to Z but in another group it can be Z to A.
Pivot function should create the columns in row order. The first on the left and the last on the right.
We can sort rows like we want and no other option is needed so that the user can simply choose order of columns of the final result.
