Concatenate multiple records into one

[snipe]

Hey guys,



I am trying to consolidate our customer account comments so we can import them into our new system that we are migrating too. In the attached pic, look at the highlighted rows. I want only 1 record per customer per day.

The first highlighted record should be for 9/25 and should be all of the text from the 5 rows for the same date concatenated into one record, with a space between them. What is the best way to go about this?

[June7]

Review http://allenbrowne.com/func-concat.html