Combining sets of attributes

Hello there,
I have a small issue combining different sets of attributes.
To be more precisely, I have a table with different movie title let's say, and each movie have 2 genre types:

Movie title Genre 1 Genre 2
Movie 1 Action Adventure
Movie 2 Crime Action
Movie 3 Action Adventure
Movie 4 SF Drama
Movie 5 Comedy Romance
Movie 6 Romance Drama
Movie 7 Drama Crime
Movie 8 SF Adventure
Movie 9 SF Action
Movie 10 Comedy SF

What I would like to create is a pivot table in which to sort by genre (column 2 + column 3) and show all movies of that genre, as bellow:

Genre
Action Movie 1
Movie 2
Movie 3
Movie 9
Adventure Movie 1
Movie 3
Movie 8
Crime Movie 2
Movie 7
Comedy Movie 5
Movie 10
Drama Movie 4
Movie 6
Movie 7
Romance Movie 5
Movie 6
SF Movie 4
Movie 8
Movie 9
Movie 10


Version of Excel used:

Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20660) 32-bit

Thank you in advance

I wonder if there's something that can be automated. If For example I add another row, I have to regenerate the green/white table again

you can use external data source and then there is no need to load the query table to the sheet, only once you get the pivot table

Sorry for the late reply. And thank you for the proposal. I didn't just solved an issue, but learned about something that I didn't know existed. So now I have to go deeper into Power Query, and for this I need to thank you

who did you write the last post to?