Merge and Search field

[Kasiop]

Dear Community,

I am looking for help for what I am sure is a very basic issue. 

Below the "data base" where each client could have several order id, so I merged all order id in one column using coma as a separator. I have merged all order id so I could use a search field. 

When I search for the client id, no issue but when I search for one (only one) order id on the search field, I have no result.

If someone can help, that will be great.

thanks,

Kasiop

[Kasiop]

Thanks again, it worked fine!

[Kasiop]

Thanks djurecicK2, 

I will try right now...

[djurecicK2 · Accepted solution]

Hi @Kasiop ,

 You might consider unpivoting the table first.

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...