Split column data into multiple columns

I have attached a snippet of a data set that I have and i would like to quickly be able to produce the output format (also attached).

I think it might be using the multi field/row formula but I am not sure as it didnt work for me.

All the values are random and you may note that the values change in the output file. My question is more around the format change rather than the values.

output.xls

alteryxquery (1) (1).xls

UPDATED - Output requirement.xls

Tips and Tricks

Best Practices

Transformation

Preparation

Accepted answers

PraphulSamavedam

Sorry buddy @h12 , I am unable to understand how the desired output has been generated from the given info. I am unable to figure out the logic by which the output has been generated.

As the data consistency in input and output has been lost and also I think code should be unique,

As per the Output code '32' corresponds to both

Country	Town
Middlesex	Hounslow
Leicestershire	Leicester

while the code '32' doesn't even exist in the input.

Attaching the workflow, incase you are able to tweak it further once you get some hint.

My present output is:

message-id_162316.yxmd

All comments

jimmke7

A question just like this is asked a few minutes ago and people are giving their solutions. Maybe you can find your solution there: Solved: how to merge rows - Alteryx Community

, Jimmy

PraphulSamavedam

I think your data is insufficient, there is no record with TownA.

I am getting completely different result, however I feel that it makes more sense.

Attaching it as it might help you.

message-id_162316.yxmd

h12

Thank you for this! I have updated the question with an updated output if that helps, but I think your solution makes sense to me!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703