Hello!
I have a situation where I need to match values that are reversed. For example, I have one row which says apple/banana and another row which says banana/apple. For my purposes, apple/banana and banana/apple are the same thing and it doesn't matter which order the output is in. Can anyone help?
current output:
| # | Type |
| 1 | Apple/Banana |
| 2 | Banana/Apple |
desired output:
| # | Type |
| 1 | Apple/Banana |
| 2 | Apple/Banana |
Thanks in advance!