Question about combining results from table with same id in one column and different info in another

[Deborah Thibodeaux]

In Spotfire, I am trying to take the results from a table with the same ID for several rows. I want to take the similar ID and the value of another text column (Role Name) and place the column result for (Actor Name) in two or more rows for matches in one calculated column.

The result is meant to identify two roles and the names of those indivivuals for each Record number

[Khushboo Rabadia]

Can you provide sample dataset and expected output screenshot to better understand your requirement. You can simply pivot the table so each row will have one id and concatenated values for role and actor names.