I am trying to get the distinguish column depending on another column's value. I was trying to approach with CASE function but could not get exactly what I wanted.
- if ColB has only 1 then online
- if ColB has only 2 then offline
- if ColB has both 1 and 2 then both
- if ColB does not have 1 or 2 then none
The result should be like this