concatenating data of the same category with delimiter in the same cell

[#1]

Hi, I have an input as below. How do I generate the summary output as below, using jmp existing function like tabulate or other, concatenating the market with delimiter "|"? 

Once we have the output, how to use jmp function to convert the output back to the input format?

Thank you!

input
Code	Market
1	A
2	A
3	A
1	B
5	B
1	C
7	C
7	A
output
Code	Market
1	A|B|C
2	A
3	A
5	B
7	A|C

[#2 · Accepted solution]

With some tinkering around in Tables and Cos menu I might have figured it out. Image instructions follow:

Start:

jthi_9-1620075325174.png

1. Tables / Split

jthi_0-1620074836053.png

jthi_1-1620074840856.png

2. With A, B and C columns selected go to Cols / Utilities / Combine Columns(might want to keep Multiple Response, depending how you use the data)

jthi_2-1620074903104.png

jthi_3-1620075040598.png

3.  Delete unnecessary colums A, B, C

4. To go back, select Market column and go to Cols / Utilities / Text To Columns

jthi_4-1620075111328.png

jthi_5-1620075117414.png

5. Tables / Stack

jthi_6-1620075133355.png

jthi_7-1620075143034.png

6. Delete Label column

jthi_8-1620075165912.png

[#3]

This works perfectly! Thank you so much!