Looking for some help on how to identify if a condition has been met, then return all values in the column associated with the compamny

Have a spreadsheet of companies we have worked with and what outputs we have delivered to them. What I’m trying to do is identify all companies that have completed a specified outcome (a C1) and return all additional outputs the company have achieved

Using the attached abbreviated example below, company ‘ABC Ltd’ would be returned twice, with the outputs C5 and E1 displayed. Company ‘Megacorp’ would not be returned as it has not met the condition of completing the output C1.’London Ltd’ returned once with output ‘C3; returned.

Example

Company name Outputs
ABC Ltd C1
ABC Ltd C5
ABC Ltd E1
MegaCorp D2
London Ltd C1
London Ltd C3

Being beyond my current knowledge I don’t know whether Excel is the best tool. This data is extracted from our CRM and we have the option to use PowerBI to complete this query.

Any help appreciated!