Filling Null Values

aliciadavoudpour

I have a data set with blanks like this:

Model	Series
Mortimer	N2
Mortimer
Rebel	Ro2
Rebel	Ro2
Rebel
Summet	P2
Summet
Wood	V2
Wood	V2
Wood

I am trying to replace the null values in the series column with the following:

- if mortimer = N2

- rebel = Ro2

- summet = P2

- Wood = V2

I tried this formula:

If IsNull([Series]) and [Model]="Mortimer" then "N2" Else[Series] Endif  but when I check the output the value is still Null, so it does not work... not really sure what else to do. 

Also, it's worth mentioning there are other values in the model and series column that what is shown, but I only need to fill these specific values. 

Any help is much appreciated 🙂

lindsey13

The data probably isn't actually a "null" value. Try using cleanse to get rid of leading/trailing blank spaces in Series. Then use your equation except instead of "Ifnull" use the "Ifempty" function. Let me know if this doesn't work, but I hope it helps! 🙂