I have a table that lists every event a customer has attended. Unfortunately there is a record for each event a contact went to. I want to create one record for each contact and in a new field put all the events they went to, separated by a comma. Below is the table... Field three is the event. The Hidden VIS field is the contact.. I want to see this as one record for contact 1040040 went to Winter Connections Brunch..., 2017 Winter Connection...,PB Temple Emanu-El... etc... Placing the event name in a new field called Events Attended
PG_Score Id cv__Event__r#Name Account__r#Id Account__r#VIS_Number__c cv__Contact__r#Id cv__Contact__r#Hidden_VIS__c CRMfusion__Index CRMfusion__Limit CRMfusion__MarkForDeletion CRMfusion__SelectionSet EVENT_ATTENDEE EVENT_INVITEE 0 a0Md000000fARd2EAG Winter Connections Brunch 2/25/16 421P 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2895 No False -1 ATTENDEE
0 a0Md000000kgGHJEA2 2017 Winter Connection Brunch 2/2/17 434H 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 74 No False -1 ATTENDEE
0 a0Md000000fA1SfEAK PB Temple Emanu-El Breakfast w/ Hal Linden 1/10/16 423X 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2282 No False -1 ATTENDEE
0 a0Md000000wKsjpEAC PB Wycliffe Parlor Meeting 3/16/17 446G 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 2529 No False -1 ATTENDEE
0 a0Md000000kghZYEAY PB Shabbat Temple Emanu-El 1/29/17 438W 001d000000Hule4AAB 1040040 003d000000Rf6y9AAB 1040040 1864 No False -1 ATTENDEE