Create new lists from an array in Excel

Hi, I would like help building a formula that creates a new list of values from an array containing a reference value in example below find all "a", "b" & "c" and populate the list with the correspo...