Code1 | Descr | Code2 | Descr2 |Level
123 | ABCD | 987 | ZYX1 | level1
456 | EFGH | 678 | ZZZ2 | level1
789 | ACBV | 999 | YYY 3 | level1
987 | ZYX1 | 000 | A123 | level2
987 | ZYX1 | 111 | B123 | level2
678 | ZZZ2 | 222 | J123 | level2
678 | ZZZ2 | 333 | K123 | level2
333 | K123 |011 | K222 | level3
I want to compare Row#1 Code2 is present in Code1. I want to group the values with level 1 to level 3.
Are you able to mock up what you would like your results to look like?
Not really sure what your goal is based on what you have provided so far