How to delete null cells

[BillyL14]

Hi there

Is it possible to delete null cells?

I want the two values to both be on row 1

thanks

[Himanshu_1984 · Accepted solution]

there are couple of ways to do it. You can use the data cleansing tool for replacing null with 0 and then use formula tool to update the column 1 by adding column 1 and 2

Regards,

Himanshu Goyal

[BillyL14]

thanks!