Easy way conversion empty to 0 - numeric

[dgudkov]

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