Hi,
I have a data set (below) where I want the value in column "Parent ID" to be copied to the column "COL1" if the value in column "MARKER" is "X". So for e.g. "Parent ID" of 1 is marked as X in column "MARKER", I want the "Parent ID" of 1 to be copied to "COL1" next to the "Parent ID" of 2. For clarity, the last table shows what the end result should look like.
| MARKER | Parent ID | COL1 | COL2 |
| X | 1 | | ABC |
| | 2 | | ABC |
| | 3 | | XYZ |
| X | 4 | | XYZ |
| | 5 | | XYZ |
The End result should look like this:
| MARKER | Parent ID | COL1 | COL2 |
| X | 1 | | ABC |
| | 2 | 1 | ABC |
| | 3 | 4 | XYZ |
| X | 4 | | XYZ |
| | 5 | 4 | XYZ |
Thank you for the help! Much appreciated!
