Check if a value is in any digit of another column

[Anonymous]

Dear all, good morning.

I am trying to check if a value in one column appear in another one. The issue I am currently facing is that the column may contain multiple values and I would need to check these one by one.

Below is the situation I am facing:

I have a table with all customer requests:

Customer	Requested Service	Status
A	Pick-up	*This column should be completed based on the other column
B	Pick-up	*This column should be completed based on the other column
C	Delivery	*This column should be completed based on the other column

And another one with the services completed for each customer

ServiceNum	ServiceType	Realised for
1	Pick-up	A,B
2	Delivery	C

Desired Result:

Customer	Requested Service	Status
A	Pick-up	Completed
B	Pick-up	Completed
C	Delivery	Completed

How may I achieve this ?

[Anonymous]

Hello @davehus , good morning.

No, I understood what you did but lets say I have a column with 10 different Customers for the realized column. I would split by delimiter "," and afterwards unpivot the selected columns right?

Lets say after 1 month I have the column with 20 customers, it will not pivot all of the 20 columns, since I selected only the previous 10 correct?

[davehus]

Hi @Anonymous , I've based the attached on your example. Please click through the powerquery steps to see how the data is being transformed. Is this what you need?

https://drive.google.com/file/d/1JfF072By-CHOUi3uzk-GMA8nVdNrKeXY/view?usp=sharing