Replace values in a column to BLANK/NULL

[ntruong1994]

Hi all,

Is it possible to replace all values in a column to BLANK/NULL using Power Query ? There are some sensitive information I want to remove but still need to keep the column header 

Really appreciate your help  

Regards, 

NT 

[dufoq3 · Accepted solution]

The easiest way is:

1. Delete your column.
2. Create new custom column (with same name as previously deleted column) and put value null.

If you want to do this for multiple columns you can use this code as a new step

Just replace Previous_Step_Name with your previsous step reference and replace "Column1", "Column2" in curly brackets with your column names (or add more).

= Table.ReplaceValue(Previous_Step_Name, null, each null, (x,y,z)=> z, {"Column1", "Column2"})