How to copy value from one column to another column

[Jairacha]

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!

[messi007]

@Jairacha,

Please see below how you can do it based on the explanation :

However I didn't get why you have 4 in COL1 for the Parent ID 3.

Attached the workflow,

Regards,

[chukleswk · Accepted solution]

You can split out your Marker columns and then join the T/F legs with each other as I've done below:

 

[Jairacha]

Thank you both for the replies!