Hello All,
Request urgent Help,
I have levels of managers in the data set column A to G where the highest level is the person appearing in the last column, note : last column might be anywhere between A to G, means to say that there are so many levels for that row..
I need to make the data look like column K to Q . Here we are trying to reverse the level to make sure we have the last poplulated column in A to G appears first in the column K and the next to the last in A to G appears next to the first name in column K to Q.
Please help.
¡Resuelto! Ir a solución.
Hi @KaushikSolanke ,
basically, it's transposing (columns to rows), reordering (from ascending order to descending order) and transposing rows back to columns. I attached a sample workflow, hope, this is helpful.
Best,
Roland
Hello @KaushikSolanke,
This should do it:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Thank you very much, this certainly is the solution, but I have other columns associated with these layers, for example, I have the Associate ID , name, position , etc etc as fields before the columns shared, when I try to add those columns, the output isnt coming out right
Thank you very much!
Hello @KaushikSolanke ,
You just need then to group by those columns on the transpose and on the cross tab tools.
Would be better if you shared an example file for us to do it.
Regards