Data Pattern

Question

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.

Alteryx Question File.xlsx

afv2688 · Accepted Answer

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

afv2688 · Accepted Answer

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