Replacing null values with blank

When pivoting columns, I noticed that when a cell has null value, the entire row will not be included in the final result. I used to replace these null values with text (like "0," for example), but it looks like a blank() value will suffice. To replace null with blank values:

Select a column (or multiple columns) > Go to 'Transform' > Click 'Replace values' > In 'Value to find' field, type "null"; for the 'Replace with' field, leave it blank/empty > Click 'OK'

In the step's formula bar, you will find this syntax:

Table.ReplaceValue(#"PreviousStepName", null, "", Replacer.ReplaceValue, {"Column.1", "Column.2", "Column.3"})

 

I hope this helps!