Hi everyone,
I am kind of stuck in this problem need your advise:
I have data that looks like this:
Option | Value |
OPTION A | TRUE |
OPTION A | TRUE |
OPTION A | FALSE |
OPTION B | TRUE |
OPTION B | TRUE |
OPTION C | FALSE |
OPTION C | FALSE |
OPTION C | FALSE |
OPTION C | FALSE |
OPTION C | FALSE |
And I am looking for output like this
Option | Value |
OPTION A | FALSE |
OPTION B | TRUE |
OPTION C | FALSE |
Basically if all values for a particular option are True then set the value as true and if any value for a particular option is false set value as false and each option should have just 1 entry.
Thank you in anticipation of your advise.
Solved! Go to Solution.
@MarqueeCrew wins
It was a photo finish @michael_treadwell you can use the Racer X image and we can team together!