Writing To A Specific Cell From Other Rows

[jonnyrask]

As you can see in the attached xlsx file. I have 4 rows and what I need to do is to replace the "?" with the Value "ABC". Obviously ABC can change and I cannot just put in replace ? with ABC. I want the final output value to become:

A	B	ABC	D
1	4	7
2	5	8
3	6	9

How can i do this? Thanks!

[Jonathan-Sherman · Accepted solution]

Hi @jonnyrask,

You could use a Field Info tool in conjunction with a Dynamic Rename. I've left the original "D" field in as i'm not sure whether you wanted to keep it:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan