Data preparation - crosstab or transposing

[mellata]

Hi all,

Am getting started into Alteryx and am having trouble doing the following manipulation.

I have many rows which have a common ID fields. I would like to put all the different values of the columns of the rows within the same row as different column values.

I currently have the following format

ID	Date	Value1	Value2
1	a	b	c
1	d	e	f
1	h	i	j
2	a	b	c
2	d	e	f
2	h	i	j

I would like to turn it into

ID	Value1(1)	Value2(1)	Value1(2)	Value2(2)	Value1(3)	Value2(3)
1	b	c	e	f	i	j
2	b	c	e	f	i	j

The order of the bc/ef/ij depends on the sequence of the dates, with the first dates to the left and latest dates to the right.

Would love to get your help!

Thanks!

[pcatterson · Accepted solution]

I think this should accomplish what you want.