Table.RemoveBlankColumns

Removes columns from a table that contain only blank values.

Syntax

Table.RemoveBlankColumns(
    tbl as table
) as table

Parameters

• tbl: The table from which blank columns will be removed.

Example

Transposing the table and changing the first column name

let
    Source = #table(
        {"A", "B"}, {
        {null, "value1"},
        {"", "value2"}
    }),
    Result = Table.RemoveBlankColumns(Source)
in
    Result

Result

B
value1
value2

Credits

• Author: Excel Off The Grid
• Source: Power Query Trick: Instantly Remove All Null Columns! 💥