Filling Null Values based on other field

[yovindapricila]

Hi everyone, 

I am trying to fill the null values based on the item column. If first row item A has weight = 10, I need the second row Item A to have weight = 10, as so forth.

Item	Weight
Item A	10
Item A	null
Item B	20
Item B	null
Item C	30
Item C	null

Can you help me create the formula to replace these nulls? 

Thanks! 

[Qiu]

@yovindapricila 
Something like this?

[christine_assaad · Accepted solution]

Hi @yovindapricila 

I'm providing a different solution in case the data won't be in order. Cheers!

[yovindapricila]

Thank you Qiu! 🙂

[yovindapricila]

Christine, this is perfect! Thank you so much.