Need help with building data validation list/filters

Hi All,   I am trying to build a new report on top of my existing(already present in one of the sheets in excel) data. The existing(source) data looks like below:   I would want the output ...