recursive multi row concatenation

[Tamanna_Patil]

Hi,

I have a list of data values that I need to concatenate. 

use case: Below table contains the products purchased by a customer and I want to see what all products he was holding before purchasing a new product. Similarly, the same goes with other customers  The column 'desired result' is the expected output.

Customer  id	Date	Order_num	Product	desired result
1	1-Jan-18	1	xx
1	2-Jan-18	2	yy	xx
1	3-Jan-18	3	zz	yy,xx
1	4-Jan-18	4	ww	zz,yy,xx
1	5-Jan-18	5	ss	ww,zz,yy,xx

I have an idea that this can be achieved by Multi-row formula but I am stuck in between. Kindly help.

Thanks

[RolandSchubert · Accepted solution]

Hi @Tamanna_Patil ,

I think, you can solve it using the Multi-Row Formula tool. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

[Tamanna_Patil]

Hey Roland,

Thanks a lot for your help. This is working exactly as expected.