Remove Nulls

[qgpl]

Hello! 

Please can someone help me get rid of the NULLS on all of formulated fields?

My expected output is:

Value1	Company Name	Account Number
437.47	DAV	IE6

I've tried a few formulas but can't seem to figure it out without removing other data from the other columns!

Thanks

Quennie

[binu_acs]

@qgpl One way of doing this