How to combine a few fields into one?

[Agility]

Hi there, I am not sure if this is a correct forum to place this question – if it’s not please let me know.

I have an excel file with logs from a web server and the “search term” people used to get to the site.

Example:
Column A:

http://www.URL1.com

Column B: toys
Column A:

http://www.URL2.com

Column B: rc cars
Column A:

http://www.URL1.com

Column B: remote submarine
Column A:

http://www.URL1.com

Column B: mini boxing ring
Column A:

http://www.URL3.com

Column B: robot
Column A:

http://www.URL1.com

Column B: Limited edition airplane
Column A:

http://www.URL2.com

Column B: radio control racing cars
Column A:

http://www.URL2.com

Column B: backgammon set
Column A:

http://www.URL4.com

Column B: Electronic helicopter

Is there any way in access to group by URL(Column A) and list all the “search terms” separated by a comma in “Column B” preferably w/o duplicates.
Like:
Column A:

http://www.URL1.com

Column B: toys, remote submarine, mini boxing ring, Limited edition airplane
Column A:

http://www.URL2.com

Column B: rc cars, radio control racing cars, backgammon set
Column A:

http://www.URL3.com

Column B: robot
Column A:

http://www.URL4.com

Column B: Electronic helicopter


Thank you very much in advance.

 

[PHV]

Take a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Agility]

Thanks for a quick reply...i'll try it ASAP.

Thanks again.

 

[Agility]

PHV - thank you very much!
Exactly what i was looking for.