Is there an Excel function for copying all results without blank cells, while searching a match in another column

Let's imagine I have a list of Companies that each has various alarms, see list below. This is normally a very long list.

. | column A | column B

1 |Company | Alarm Type

2 |BB ...........| alarm-1

3 |AA ...........| alarm-7

4 |CC ...........| alarm-32

5 |BB ...........| alarm-4

6 |AA ...........| alarm-1

7 |CC ...........| alarm-7

8 |BB ...........| alarm-33

9 |CC ...........| alarm-1

10 |BB ..........| alarm-88

I need a list of all alarm types that a company has. I define the lookup value in cell C1, so I can change the search term from AA to CC or BB, depending on my needs at the moment.

In column D, I want a return list without any blank cells.

I have tried the simple IF(Company=lookup value;Alarm Type;"") but that leaves me blank lines. The same happens when I used INDEX and MATCH

For example, if I search for Company CC, i want results like this:

. | column DD

1 | Alarm Type

2 | alarm-32

3 | alarm-7

4 | alarm-1

What I do not want, is this:

. | column DD

1 | Alarm Type

2 |

3 |

4 | alarm-32

5 |

6 |

7 | alarm-7

8 |

9 | alarm-1

10 |