Forum Discussion
Solved
Search Multiple Value in different columns
Hello, I'll start by saying that I'm French so my English can be a little messy. I have a table which contains one identifier column and 4 columns filled with different words like below: Id...
For your question, here is the method I provided:
You need a virtual table and go into the power query to do unpivot.
"Table"
" virtual table"
Click "Transform data" to enter the power query.
Unpivot columns.
Create a relationship.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your solution. It works perfectly