Multiple Criteria to pull multiple values in Excel Summary Table

DESCRIPTION:
Hi, I need some help to read text and output it to a summary table with multiple criterion. I have to use excel formulas to accomplish this. It is easy to do it with pivot tables but the end user is not tech savvy.
Tab 1: Raw data with information Tab 2: Example of dummy data. Basically, need to read text from column C, D, E in Raw Data - Tab 1 based on 2 criterion (Pillar and Group - columns A, B in Tab 1) and then spit out results in Tab 2 - Desired output. Note that in some cases there is more than one date/value to spit out in the column. Please help.

Criteria should be based on Column A and B (Group and Pillar) ....
and when the criteria meets, it may or may not have more than 1 value (for example: Group 1, Pillar 1 might have 2 dates/values in column C, D, E so I have to pull both dates in my summary table.

Please see attached data ("example 1.xlsx")

Thank you!

That's too bad, the solution to this would've been a help with an issue I came across at work yesterday. Guess I'll keep looking for an answer.

Originally Posted by Melvosh

All that's being asked is for you to provide links to the other posts you made, so that we don't end up duplicating work that someone else is doing

Right, except I'm not the person who posted this. Just someone who would have also benefited from the answer without having to add another post to come to a similar conclusion, was all I was saying.