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

joann

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

jthi

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

Start:

 

1. Tables / Split

 

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)

3.  Delete unnecessary colums A, B, C

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

5. Tables / Stack

6. Delete Label column