Appending to the new row

[goeld]

Hi Everyone,

I'm a newbee to Alteryx and I have a small requirement to build the workflow:

Comparing the current row to the previous row. if the current row of the first three columns are same to the previous row then the last two columns data should be appended, otherwise data should remain same  Eg:

A	B	C	D	E
1	2	3	4	5
1	2	3	6	7
5	2	4	8	9

Here, in the above table first two rows are same for first three columns therefore the data should be appended for the column D and E and third row data should remain as it is:

Output:

A	B	C	D	E	D1	E1
1	2	3	4	5	6	7
5	2	4	8	9

[danrh · Accepted solution]

There's likely a better way to do this using only Multi-Row Formulas, but I jump at the chance to use Transpose/Cross Tab:

This can handle however many duplicates you throw at it and will split them into individual columns.

[goeld]

Thanks it worked :)