PQ - Remove columns contain null on the end

[sandy666]

Remove columns contain null on the end


Column1Column2Column3Column4Column2Column4

ADIMDM

BEJNEN

CFKOFO

GLPGP

HRHR



let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
TSC = Table.SelectColumns(Source, Table.SelectRows(Record.ToTable(Table.Last(Source) ), each [Value] <> null)[Name])
in
TSC