Input:
Expected output:
I want to copy the names but keeping the same id. Thank you.
Hi @BautistaC888,
I have created a workflow for you:
The output:
With the Multi-Row tool, you can refer back to prior rows. For example, you can easily construct a formula that says if the row is null, then take the value above it. Give it a try and let us know if you were able to get it!
@Emil_Kos - thank you very much for this, it helped me solve the same problem
Happy to help @NikiJF
If you want to read more about the multi-row formula tool I strongly recommend this tool mastery page written by @Kenda.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603
