Here in this image, we can see there is a table of a database of a number of customers who have attended events in our company, but events were conducted separately so we have data separate with the name of the event by the side.
The only common item is their phone number.
So what I need is: Sam has attended three events it has three rows with the names in it, compile it in a new column called consolidated with a code E1E2E3 so now instead of three rows there is one row with this code
This code helps us understand sam has attended these three events.
Kindly please assist me in providing the formula,