Hello, I have a dataset that looks like this, there is a matching key that goes in zig-zag pattern, there could be more than 3 changes
Input:
| Source | Target |
| aaa | bbb |
| 111 | 222 |
| bbb | ccc |
| ccc | ddd |
| +++ | --- |
Output needed:
| Source | Target |
| aaa | ddd |
| 111 | 222 |
| bbb | ddd |
| ccc | ddd |
| +++ | --- |
I have done it using Join tool, but would like to see if there's a better way to solve it
I have tried Make Group tool but it seems it will fail if the combination is like below, where it outputs 777 - 999 instead of 999 - 777:
Thanks!
