Replacing values in one column with values from another if another column is NULL

[trevian3]

Hello Alteryx Community,

I'm probably overthinking this, but I have source data organized as shown below. What I want to do is, for the null values in the prioritized fill line column, I want to replace the capacity in the capacity column with the capacity of the other capacity value that is shown for the fill line that has a fill line and prioritized fill line value. 

For example, for the fill line "Sample2" shown below, for the line that has a null value in the prioritized fill line column, I want to replace that capacity that's in there for that row of 2520000 with the one below it of 63000000.

.

Fill Line	Prioritized Fill Line	Pkg Line	Prioritized Pkg Line	Capacity
Sample1	Sample1	SETUP3	SETUP3	37000000
Trade6 to Sample2/Sample4	Trade6	SETUP6/SETUP9	SETUP6	63000000
Sample2		MANUEL	MANUEL	2520000
Sample2	Sample2	SETUP6	SETUP6	63000000
Sample3		MANUEL	MANUEL	2520000
Sample3	Sample3	SETUP8	SETUP8	61000000
Sample4	Sample4	SETUP9	SETUP9	77000000
Trade5		MANUEL	MANUEL	2520000
Trade5	Trade5	SETUP1	SETUP1	140000000
Trade5	Trade5	SETUP1/Pharmadis	SETUP1	140000000
Trade5	Trade5	SETUP7	SETUP7	140000000
Trade5	Trade5	SETUP7/SETUP5	SETUP7	140000000
Trade6	Trade6	SETUP1	SETUP1	140000000
Trade6	Trade6	SETUP4	SETUP4	140000000
Trade6	Trade6	SETUP4 to SETUP1	SETUP4	140000000
Trade7	Trade7	OPTILINE1	OPTILINE1	200000000

Is there a way to do this with a formula? 

__PRESENT

[vannat]

I would filter out the nulls, summarize then join back to your original dataset.  throw in a formula to replace the null value.  

[binuacs · Accepted solution]

@trevian3 one way of doing this

[CoG]

Here is what I believe to be the optimal strategy; you can Sort and then use the Multi-Row Formula Tool to propagate the values downward:

Hope this helps and Happy Solving!

[trevian3]

Thanks everyone for all of the suggestions!