Forum Discussion
Replace blanks with null
Dear friends i need to fill down column but its cant because its not "null" how can i convert blank cell into null. thank in advance for any suggestions.
Anonymous ,
Use replace to achieve this.
Leave Value to Find as empty and replace with null.
In M-Query it looks something like below.
= Table.ReplaceValue(#"Replaced Value","",null,Replacer.ReplaceValue,{"COLUMN"})
Try replacing the column name and add the above line in advanced editor else use the first step.
Regards, '
Manikumar
If you find this is helpful, Accept as a Solution and leave a like.
manikumar34
Solution Sage
Solution SageAnonymous ,
Awesome , you got the answer.
Your kudos will be appreciated 😊
Regards,
Manikumar