Trying to Merge/Combine Information

Hello,

I'm currently using Excel 2010 and I have a merging question. I'm working with this database...


PersonID CategoryID
1 Doyle
1 Non LT-Client
1 Prospect
2 Client
2 Doyle
2 Prospect
3 Client
4 Prospect
5 Prospect
6 Arbor Prospect
6 Client
7 Prospect
7 Seminar No-Show
8 Prospect
9 Arbor Client
9 AVIVA
9 Non LT-Client
9 Prospect
10 Prospect
12 Prospect
13 Prospect
14 Prospect
15 Prospect
15 Seminar No-Show
16 Prospect
17 Prospect
18 Prospect
19 Arbor Prospect
19 Client
20 Client
21 Prospect
22 Prospect
24 Prospect
26 Prospect
27 Prospect
28 Client
29 Prospect
30 Prospect
32 Arbor Prospect

And it goes on for thousands of entries. I am looking for a way to combine the information in the second column into 1 cell for each # in the first column. For instance, Person ID 1 has 3 different Category ID's. I just want there to be 1 row with Person ID 1 and the 3 descriptors (Category ID's) in one cell. How do I combine that information??

Thanks,
Tracy

I think this is what you need, see workbook attached below.

Recycling my old code, it was first posted here
http://www.excelforum.com/excel-form...-required.html

OMG, that worked GREAT! Thank you so very much! You are a life saver!