Hi
I'd like to sort column A based on a column B which contains previous values from column A.
This is what I have:
| ID | A | B |
|---|
| 1 | 17209061 | |
| 2 | 53199491 | 51249612 |
| 3 | 61249612 | 17209061 |
| 4 | 51249612 | 61249612 |
And this what I'd like to have:
| ID | A | B | Sort_seq |
|---|
| 1 | 17209061 | | 1 |
| 3 | 61249612 | 17209061 | 2 |
| 4 | 51249612 | 61249612 | 3 |
| 2 | 53199491 | 51249612 | 4 |
I'm sure there's an easy way to do this. Do you have any ideas?
Thank you!