How to split the data by column

[Kuha]

Hi, I want to split the column and join it. Basically reversing the crosstab. Any suggestions, please?

Prod ID	Period 1	Period 2	Period 3
2275	120	458	71
4548	144	56	29
11443	126	47	34
12019	55	899	65
12218	34	64	41

Prod ID	Period1	Qty
2275	Period1	120
4548	Period1	144
11443	Period1	126
12019	Period1	55
12218	Period1	34
2275	Period2	458
4548	Period2	56
11443	Period2	47
12019	Period2	899
12218	Period2	64
2275	Period3	71
4548	Period3	29
11443	Period3	34
12019	Period3	65
12218	Period3	41

[DataNath · Accepted solution]

Hey @Kuha, to reverse a Cross-Tab, you just need to use the Transpose tool. In your case, just ensure you group by Prod ID:

[binuacs · Accepted solution]

@Kuha The transpose tool will reverse the cross tab output

[Kuha]

Thanks, @DataNath

I am new to Alteryx. Thanks for your speedy response. I tried it works.

Kuha

[Kuha]

Thanks, @binuacs 

You guys are great.

Kuha