Fill cell if null

[Hamder83]

Hi 

I have 1 data stream fx:

   Service, Parcel number, Weight 
1: Freight, 123456789, 10 kg  

2: Oil fee, 123456789, null 

And i want to add the weight to the 2. row with the weight data from row 1.

Where 1.Parcel number = 2.Parcel number.

But I cannot figure the right way to do it?

[NickSm · Accepted solution]

Hey @Hamder83 

Can often use the Multi-Row Formula tool to fill down columns.  In this example, can check the box to group by Parcel number to make sure that it's only filling cells for the same parcel number.  Depending on what your full data set looks like you may need to add some additional logic, but a fill-down like shown here gets used quite often.

Example attached

[Hamder83]

That seems to do the trick.

Tho I have to sort before using the formula, so I always have the line with data as beeing -1 and not +1 ?