Skip to content
Advertisement

How can I make all values of one identifier the same based a on value in a row?


Here is the code I’m using, and the data I’m getting is:

Data sample receiving

But I want the data to look like this:

Data I need

Basically, I need this:

You see item789 has 111 in one of the rows, therefore I need all the other rows to say “present” for item789. The others don’t have 111, so they have no 111 present. Does this make sense?

Advertisement

Answer

You can use EXISTS :

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement