Power Query by Default Excludes First Blank Column

With Excel is practically the same, the only you have to define sheet name to combine

let

    SheetToSelect = "Test",
    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 = Excel.Workbook(Parameter1, null, true){[Item=SheetToSelect,Kind="Sheet"]}[Data],

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