Add value from multiple rows to once cellHi 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

Advanced Statistical ModelingData Blending and CleanupQuality and Process EngineeringSharing and Communicating ResultsRe: Add value from multiple rows to once cellYou 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...