Question for Repeating Group

Jobs / Freelance
1

I have a table that among some columns will have a column that is link of a option set. For this test let’s call it Test

No My table has this results:

REC Options

  1.         Test1,Test2

  2.        Test1

  3.         Test1,Test2,Test3

Now how do I make to show these records come to a text like this:

Test1;Test2,Test1,Test1;Test2;Test3 ?

So basically I want to join options within the same record by: and than join options between records with ,

2

As the text are list use :formet as text on that list and give it a delimiter. That set