Concatenating 2 rows using Scribe

Lets take an example. I have a lookup table which looks like this:

Value 1 Value 2

R1 Session 1

R1 Session 2


Now I want to concatenate value 2 in both the rows as value 1 (R1) is same for both the rows. In the end, the output I want is Session 1, Session 2.

Any help is appreciated.

(10) Answers