yogi_List Unique Values In Column A And Concatenate corresponding Values In Column B

Google Spreadsheet   Post  #2474

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-14-2018

question by: Joshua Lingan
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/fHyHV4qmTCk;context-place=forum/docs
List Unique Values And Concatenate Corresponding Values??

I want to do something similar to this, but on Google Sheets. How would I go about doing it?

here is the link for a sample sheet: https://docs.google.com/spreadsheets/d/1yopKwn3vAJpgqbhLg8UFB2DmM4IjbP9YC8i2Qu6-g6w/edit?usp=sharing

I would use e-mail address column as the lookup value (unique value?) and Date Attended as the corresponding value..

So something like email | Date Attended (all values without adding duplicate values)

And if possible for the Date Attended values to be separated by a ";"