Alternative to Multiple Multi Row Formula Tool to Pick above Row Values if null

[harshal98]

Have to fill in empty values basically null values with the values above group by id.

But there are many columns so have to go with multiple Multi Row Tools...What is the Alternative that i can do it for all columns at once?

InputOutput

[AngelosPachis]

Hi @harshal98 ,

Try using a transpose tool before the multi-row formula tool to pivot all fields that you want to fill in values with the multi-row formula tool.

Then, make sure you configure the multi-row formula tool as shown below:

That will restart the calculation for each id and Name field, assuring your tool works properly. 

Hope that helps, let me know if that worked for you.

Regards,

Angelos