Forum Discussion
Solved
How to match multiple values from multiple look up values
Hello dear all, I'm trying to find a formula which allows me to create look up between my 2 tables. Table1 contains a list of movies (single values) + for each movie the list of actors playing in...
In Power Query, split your Actors column in your Movies table by delimiter (,). Then unpivot those columns. You will end up with:
Movie,Actor
Albert,A
Albert,B
Albert,C
Albert,D
Bernard,A
Bernard,B
Bernard,D
...
This will allow you to achieve what you want.
