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!
Solved! Go to Solution.