How to replicate data from one field to other?

1

I have this schema: Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

And I want to replicate the data in some of the fields in few other fields of a different table. Screenshot below:

image.png1474×625 364 KB

Is there a way to achieve it for XML outputs? My current formula throws an error - ‘Field not found’.

Thanks