Concatenating multiple comments into one row
Posted on 2016-11-18
I need to concatenate comments based on the customer ID, activity date, activity code, activity time.
I wrote code to get the duplicate number which tells you how many rows one comment should consist of.
I need assistance how to concatenate the rows into one where the dup number is greater than 1.
I have attached a picture and highlighted what I am looking for.