Unsure of how to perform query and results..

Hi Guys, I have data in a Db that looks something like: 14,smithcanada@somedomain.ca,Andrew,Smith 1,smithcanada@somedomain.ca,Andrew,Smith 14,b-richardson@somedomain.com,Barbara,Richardson 1,b-richardson@somedomain.com,Barbara,Richardson The number represents a product_id that was purchased by the customer in question. As you can see from this example.. I have a two customers who purchased two different products. What I NEED to do is have one entry for each customer but with both their product_id in the same result. For example: 14,1,smithcanada@somedomain.ca,Andrew,Smith ANY clue how I could go about getting this to work? I'm very desperate and running out of time :-( Thanks so much! Aaron