Hello Everyone,
I am playing around with Alteryx to assess it for a project. Can anyone help me with this use case? I have the incoming data as
Manager ID | 123 |
Manager Name | ABC |
City | Kolkata |
State | WB |
I want the output as
Manager ID | Manager Name | City | State |
123 | ABC | Kolkata | WB |
This is a very simple transpose in Alteryx. Just wandering how to achieve this in Alteryx.
Solved! Go to Solution.
@arnabd100 Also very simple in Alteryx!
Just use a Cross Tab tool and select your first field as the new headers and your second field as the values for new columns. Just select Concatenate for the method to aggregate, but it won't matter for this sample data.
Thank you so much. It worked like magic.