combining Excel files with dfferent columns

Hello - yes, this is possible.  You would just change the portion of the script that removes columns to only remove those that have duplicates, not to remove the empty columns.

BEFORE

    // Combine duplicate plan columns and generic columns into one list.
    ColumnNamesToRemove = List.Combine ( { DuplicatePlanColumns, GenericColumnNames } ),
    // --------------------------------------------------------
    // Clean up the column names. 
    // --------------------------------------------------------
    // Remove specific columns from the source table.
    RemoveColumns = Table.RemoveColumns ( Source, ColumnNamesToRemove ),

AFTER

    // Combine duplicate plan columns and generic columns into one list.
    // ColumnNamesToRemove = List.Combine ( { DuplicatePlanColumns, GenericColumnNames } ),
    // --------------------------------------------------------
    // Clean up the column names. 
    // --------------------------------------------------------
    // Remove specific columns from the source table.
    RemoveColumns = Table.RemoveColumns ( Source, DuplicatePlanColumns),