Copy values on the row below

[BautistaC888]

Input:

Expected output:

I want to copy the names but keeping the same id. Thank you.

[mbarone]

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 · Accepted solution]

Hi @BautistaC888,

I have created a workflow for you:

The output:

[NikiJF]

@Emil_Kos - thank you very much for this, it helped me solve the same problem

[Emil_Kos]

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...