Alteryx Desktop Cross Tab

[RKahle]

Hello, I am trying to cross tab the attached so there is (1) record with a new column for each destination. For this example, there will be (1) record with (4) columns. RecordID, Destination 1, Destination 2, and Destination 3.

[Prometheus]

@RKahle You can use the Transpose tool to do that. I added another couple of records with another RecordID to show how the Tile tool can group these and count how many exist for each RecordID. Is this what you're looking for?

 

 

 

[binu_acs · Accepted solution]

@RKahle One way of doing this