FILL IN THE MISSING ROWS UPWARD

[dunkindonut7777]

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

Data:

Code	Expected output
	12
	12
12	12
	11
11	11
	10
10	10
	13
13	13

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

[JosephSerpis]

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

[danilang]

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