FILL IN THE MISSING ROWS UPWARD

Question

Hi I would like to ask if how can I fill in the missing values upward in a cell.

Data:

CodeExpected output 12 121212 111111 101010 131313

Is there an easy way of how can I do this? thank you

danilang · Answer

Hi @dunkindonut7777

Try this

Since the multi-row tool only fills down, add a recordID and sort by recordID desc, which reverses the order of your list.  Use a MultiRow to fill this list down and restore the original order with a second Sort tool.

Dan

UpwardFill.yxmd

JosephSerpis · Answer

Hi @dunkindonut7777 I took an approch of sorting your data and then filling downwards and reordering back to the orginal order.

Fill_Empty_Rows_28112021.yxmd