Automatically sorting data according to defined categories

Hello everyone!

First I would like to apologize if this problem has been mentioned/solved before, but need help....
I have two columns, in column A will have four or five categories repeating randomly, in columns B will have unique names.
What I would like to do is to define categories as a column names in a table and then to automatically fill that table with the data from column B depending on category.

Please find attached a table, it will be more clear what I would like to do....

I suppose it cannot be done with pivot tables, so please any help or link to to explanation would be much appreciated.

Thanks in advance.

Oliver

Thanks a lot!!!

I am not very familiar with array formulas, but will try to figure out how this works!

Thank you for your help!