Transpose Incoming Data

[arnabd100]

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.

[Kenda · Accepted 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.

[Thableaus]

Hi @arnabd100 

Cross-Tab tool can solve your problem.

Cheers,

[arnabd100]

Thank you so much. It worked like magic.