Transpose Cross Tab solution needed

[LisaD]

Help!  I've got Alteryx writers block on a Friday.

I'm trying to take the first table and make it look like the second table.  Renaming column header with the Record Number.

Thanks in advance!

Record	Name	Value
1	Customer	ACME
1	Market	Market1
1	Zip	32258
2	Customer	RoadRunner
2	Market	Market2
2	Zip	64152
3	Customer	BugsBunny
3	Market	Market1
3	Zip	33352
4	Customer	Jerry
4	Market	Market1
4	Zip	32258

Name	Record1	Record2	Record3	Record4
Customer	ACME	RoadRunner	BugsBunny	Jerry
Market	Market1	Market2	Market1	Market1
Zip	32258	64152	33352	32258

[FinnCharlton · Accepted solution]

Hi @LisaD , you just need a crosstab tool here. Check out the example workflow attached, hope it helps!

[binu_acs]

@LisaD One way of doing this

[binu_acs]

@FinnCharlton to add the image to the reply save the image then use the insert photo option in the reply window

[LisaD]

Argh - I knew it was an easy one but just couldn't see it!  Thank you very much