Hi.  I run into some trouble.  I have the data in the following long format.    PID 1 - Drug A PID 1 - Drug B PID 1 - Drug A PID 1 - Drug C PID 2 - Drug B PID 2 - Drug C PID 2 - Drug C There are duplicates and I would like to transform it into wide format like this. PID 1 = Drug A Drug B Drug C PID 2 = Drug B Drug C I tried to use nodupkeys but if I did that, PID 1 would only have Drug A and it would delete the other 2. Thanks ! ... View more