Add value from multiple rows to once cell

[#1]

Hi folks,

I want to insert multiple values into one cell. I have manually done it in the screen grab so i want the value from row 1,2,3 to be joined together and added to 3 rows.
Not sure how to complete this, do i need more identifiers so it can join the code. sorry I cant share the dataset due to IP reasons but below is a snippet

[#2]

You can use a formula....

If contains(Process RC 2 , "RC1") then concatenate("[", char(:blasmultiplier), "," , lag(-1, char(:blasmultiplier)), lag(-2, char(:blasmultiplier)) )

else lag(1, Column 59)

That is a rough rendition....hopefully enough for you to figure it out...