How to drag down data on a column

Question

I have data on a column on the first row, then in like row 150, then in like row 450 etc. Each data is different. I want to drag the data down from row 1 to 149, then from 150 to 449 etc. See example below of what my data looks like.

row 11X10 Null

Nullrow 150XYZ Null Null Nullrow 450ABC1K

Bren_Spill2 · Answer

Hi @Taxautomation - you will need to use a multi row tool to achieve this. This will allow you to pull data from previous rows and copy it down until you hit a row that has data in it. You will need to update the field with an expression:

if isempty([Field]) then [Row-1:Field] else [Field] endif    (will be isnull instead of isempty in your example)

Try this and see how it goes