concatenating data of the same category with delimiter in the same cell
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 CodeMarket1A2A3A1B5B1C7C7A output CodeMarket1A|B|C2A3A5B7A|C