Combine Excel tables from one column but keeping another column data

I can see how you may want to avoid needing to explicitly call out which columns you want to expand.

One solution: add the [ProjetDalux] text values to your tables in [Personnalisé.Data] and then combine as you were before. Something like:

= Table.Combine( 
    List.Transform( 
        Table.ToRecords(#"Lignes filtrées"), 
        (row) => Table.AddColumn( row[Personnalisé.Data], "ProjetDalux", each row[ProjetDalux], type text ) 
    ) 
)

Edit: changed from using Table.ToRows to Table.ToRecords as the latter will work regardless of column order.