Transpose New columns

[saivig68]

Hi All,

I have the following table 

Table 1:

ID	Order	Item
1	1	A
1	1	B
1	1	C
1	2	A
1	2	D
1	3	A

I need to transform it into the following format 

ID	ORDER	1	2	3
1	1	A	B	C
1	2	A	D
1	3	A

Which tools do I use?

[DanM]

Hi @saivig68, Thank you for your contribution to the Community! The Alteryx Community is here to assist you with questions, issues and ideas. We ask that you attempt to build the workflow on your own as a first step. If you encounter specific issues or errors along the way, the Alteryx Community is here to help! Here are some resources to help you get started:

REGEX

Formula Tool

Thanks,

DanM

[Derangedvisions · Accepted solution]

hi!

you can use the Cross tab tool - are you wanting the Order # to be your new column headers? or are those ID #'s? 

if you use the Order # as your new headers I get different results- so i might be misunderstanding what you are looking for... you can configure the cross tab tool in multiple ways- so let me know if i'm way off what you are looking for! :)

[saivig68]

Those are new column names or no column names

[saivig68]

Sure @DanM will try to follow that for future discussions.