Input:
Expected output:
I want to copy the names but keeping the same id. Thank you.
Solved! Go to Solution.
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