Forum Discussion
Replace values to null
Hi, I want to replace all values in all selected columns to null. In general, main aim is to Fill down all cells with value, but at first need to clear all previous information. Is it possible? Best ...
If you select the columns that you want to have the null replaced and and then right click and use the replace value option on the pop up menu it will create this step that works with the selected columns
= Table.ReplaceValue(#"name of previous step",null,"",Replacer.ReplaceValue,{"Column", "Column1","Column2","ColumnN"})