Dynamic M Function to Replace Blanks with Nulls ( #DataCleaning, #MCode, #M, #PowerQuery )

gistfile1.txt

let
    ReplaceBlanksWithNulls = (inputTable as table) as table =>
        let
            columnNames = Table.ColumnNames(inputTable),
            replaceBlanksInColumn = (table, columnName) => Table.ReplaceValue(table, "", null, Replacer.ReplaceValue, {columnName}),
            transformedTable = List.Accumulate(columnNames, inputTable, (state, current) => replaceBlanksInColumn(state, current))
        in
            transformedTable
in
    ReplaceBlanksWithNulls

I had a weird issue where NULL was stored as a string in some data I received, this would be a good solution for that too. Thanks for sharing! Darrell