Multiple Criteria to pull multiple values in Excel Summary Table

[dsb3465]

DESCRIPTION:
Hi, I need some help to read number and output to a summary table with multiple criterion using an excel formula. It is easily done using pivot tables but my audience is not tech savvy and need a formula to extract the values from Tab1.

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 extract out based on the criterion.

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 for example. so I have to pull both dates in my summary table.

Please see below the data and excel file ("example.xlsx").
https://drive.google.com/file/d/1n41c553oQGM9V0LCMzUciDfuE-fphNs8/view?usp=sharing



Thank you!

 

[dsb3465]

sample data file link:
https://drive.google.com/file/d/1n41c553oQGM9V0LCMzUciDfuE-fphNs8/view?usp=sharing

 

[Joe4]

Cross-posted:
https://chandoo.org/forum/threads/m...multiple-values-in-excel-summary-table.41169/
and
https://www.excelguru.ca/forums/sho...lues-in-Excel-Summary-Table&p=40573#post40573

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[sandy666]

use PivotTable, Group and Pilar to Filter area, the rest to the Row area