Build array with multiple filters

Allo,
I have a simple list of systems located in rooms. I have new data regarding certain rooms and i need to figure out which system is impacted.
If I had 4-5 rooms impacted I would use a filter, but I have decent amount of rooms impacted.

As a result, I would like a list of two columns:
- The first one being the system name (A, B, C...)
- The second one being the room into which it's located
which is prettymuch the raw data filtered by impacted rooms.

Any nice way to that?

Thanks