Help with CrossTab!!!

[kkkim]

Hi, Alteryx Community:

I am looking to transpose the data to show as final state below: 

Currently, data is showing as below:

Original Status

Field 1	Field 2	Field 3	Field 4
A	apple	banana	peach
B	123	345	678
C	abcd	efgh	abcd
D	alteryx	alteryx	alteryx
E	apple	banana	peach
F	123	345	678
G	abcd	efgh	abcd
H	alteryx	alteryx	alteryx
I	123	345	678

I would like to transpose it to show below:

Ideal State:

A	B	C	D
apple	123	abcd	alteryx
banana	345	efgh	alteryx
peach	678	abcd	alteryx
cherries	111	efgh	alteryx
avocado	222	efgh	alteryx

Thank you so much for your help!

[Luke_C]

Hi @kkkim 

Where do the 'cherries' and 'avacado' values come from? How do you determine which values to use? For example I see multiple apple values (A, E) as well as multiple '123' values in field 2 (B,F, I). Column I also seems to break the pattern of fruit - number - letter - alteryx. Is that correct?

[kkkim]

The values should all be different! sorry for the confusion. it should be a straight transpose with column realignment. There should not be repeating values... Thank you!

[Luke_C · Accepted solution]

Then just something like this then?

[kkkim]

Yes! Thank you so much!