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
Hi @dunkindonut7777 I took an approch of sorting your data and then filling downwards and reordering back to the orginal order.
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