Combining Records

[sr71aa]

Hello,

I seem to have a similiar problem to others and I tried to read through this forum, but I am not well versed in the code and I frankly find some of the explanations way to complicated. I was hoping someone can help me with a problem. I have data that looks like this:

Name Comments
J Smith 1/1/07-ATO
J Smith 1/10/07-UAU
S Smith 1/13/07-ATO
D Smith 1/2/07-OT
D SMith 1/3/07-OT
D Smith 1/4/07-ATO

I want it to look like this:

Name Comments
J Smith 1/1/07-ATO, 1/10/07-UAU
S SMith 1/13/07-ATO
D Smith 1/2/07-OT, 1/3/07-OT, 1/4/07-ATO


ANy suggestions?

 

[sr71aa]

Thanks! I really appreciate it. I looked at the example but I don't understand the fConList portion. It looked like a function, but when I try to duplicate it, I get an error. What exactly is fConList and how do I use it?