Thread: Combining multiple dates (in different cells) into 1 cell

So I'm working on a report and I can't seem to find a formula to meet what I want.

I have a huge export that contains the following information
Column A: Student Name
Column B: Entry Date
Column C: Type of Entry
Column D: Entry Text

Now this is what I want it to look like, using the following workbook as an example. The majority of it is quite easy. The only problems I'm having is having Excel search a huge export and put the dates in a cell for every instance the student has a certain type of update. For example, in the Wave Advocates Update column, I want the date to pull up every single date that a certain student has had a "06-Wave Updates"

In the reports tab, the Student Names and Advocates is entered manually and the Total # at the end I use =SUMPRODUCT, which works fine. I didn't enter the formulas because I really don't know what to use.


Please Help!! Thanks

- Santana

Still haven't been able to figure this problem out.