How to drag down data on a column

[Taxautomation]

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 1	1X10
	Null
	Null
row 150	XYZ
	Null
	Null
	Null
row 450	ABC1K

[Bren_Spill]

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