Horizontal autofilter with colours.

[Knijn]

Hello there,

I am currently working on an inventarisation-list and want to do the following:
I have 2 frozen rows on the left side, and ~40 different servers all in a different column.

Through an auto-filter I made a list of software so I can select and 'colour' a cell green if it's on the server, and red if it's not for example.

What I want to do, is make another AutoFilter but this time horizontally, so that when I select "Green" I get all the software that's installed on this server.

I am horrible with Excel on it's own and I am not sure how to word this in a few lines, I hope you can offer me some help on this.

Thanks in advance,

Rknijn

EDIT:
I've solved this myself with a different solution.