Tables - creating columns out of filters

[need excel]

I have a table with 2000 movie names assigned to their departments with many of them overlapping. is there a way to create a new column with the filter?

For instance:

I have:
Movie | Department

Movie 1 | Horror
Movie 2| Comedy
Movie 2 | Romance
Movie 3 |Horror
Movie 3| Comedy



I want:

Movie | Department of Horror | Department of Comedy| Romance

Movie 1| Horror | nothing |nothing
Movie 2 | Nothing | Comedy | Romance
Movie 3| Horror| Comedy


I hope this makes sense.

Thank you so much.

 

[Somendra Misra]

Hi,

See the file, Yellow cells has the required result, based on my understanding of your problem. Just see if this make sense.

Regards,