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?