How to stack multiple columns within a data set?

jaipersr

Hi I am trying to stack multiple columns of a data set in Alteryx. I will show my data below.

Group 1	Score 1	Group 2	Score 2
A	1	E	5
B	2	F	6
C	3	G	7
D	4	H	8

I want it to look like the following:

x	y
A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8

However, this is not a simple transform tool operation. I need to pivot both my Group columns as well as Score columns and I need the relationship to be one to one. I figured out how to do this using 2 Transform tools. One with respect to only the Group columns and one with respect to only the Score columns. And then joining by record position later on but my question is how to do this in one step? Is it possible or is the way I just described the best possible solution?

fmvizcaino

Hi @jaipersr ,

Example attached. See if this works for you.

Best,

Fernando Vizcaino

2020-03-31 How to stack multiple columns within a data set.yxmd