Easy way conversion empty to 0 - numeric

1

I import an excel WB. The columns are numeric. Some cells can be empty iso zero.
How can I modify the columns to 0 without using a rule on each of the columns - and I have a lot.

I am comparing two columns - one with zero in it and one with empty. It then returns that there was a change as zero <> empty.

Thanks

2

You can unpivot your table, replace empty to 0 in one column and then pivot it back. See this topic: Pivot back to original dataset

3

Excellent, Thanks