Power Query by Default Excludes First Blank Column

If to assume you combine csv files, for them Power Query removes blank columns before first one with data. And after last one with data if number of columns is not specified. If you check Transform Sample File query, it could look like

let
    Source = Csv.Document(Parameter1,[Delimiter=",", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None])
in
    Source

where options, in particular number of columns, are automatically taken from the analysis of first sample file.  Resulting table  by default has headers Column1, Column2, etc.

 We may modify that query so if resulting table has one column less, headers will be Column2, Column3, etc.  In combined table columns will be arranged by their column names, thus we will have correct order of columns. Modified Transform Sample File query could be

let
    NumberOfColumns = 4,
    NewNames = List.Zip( {
        List.Transform( {1..NumberOfColumns-1}, (q) => "Column" & Text.From(q) ),
        List.Transform( {2..NumberOfColumns}, (q) => "Column" & Text.From(q) )
    } ),
    Source = Csv.Document(Parameter1,[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None]),

    n = Table.ColumnCount(Source),
    AdjustColumns =
        if n < NumberOfColumns
        then Table.RenameColumns( Source, NewNames )
        else Source
in
    AdjustColumns

Don't forget to remove Columns=4 option in Csv.Document(), that's the key. And use your actual number of columns instead of 4.

Most probably similar could be done if you have another setup.