Help Needed: Copying Values Downward in Empty Cells Until Next Value

Question

Hello all,

I need help with a task where I want to copy a value downwards in empty cells until the next nonempty cell is encountered. Essentially, I want to fill empty cells with the value from the cells above until a new value is reached, and then repeat the process. Can you help me with this? I have attached a sample of my dataset.

Transactions.xlsx

rzdodson · Answer

@KafuiGodzi If I understand your requirements, I think that a Multi-Field Formula (Preparation palette) tool will be your saving grace here. Below is the syntax I used.

If !isnull([Date]) and !IsNull([Row-1:Account Name]) and IsNull([Account Name]) then [Row-1:Account Name] else [Account Name] endif