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

@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.