Copy headers

[Anonymous]

I have an Excel where I want to combine the two sheets using Power Query.  This is very easy when the both sheets have the identical headers but sheet 2 has none.  I can copy and paste the headers in and it works but can I use Power Query to do this for me?

[Anonymous]

So if you have 2 tables Table_W_Headers and Table_No_Headers, then you could rename the headers like

Table.RenameColumns(Table_No_Headers, List.Zip({Table.ColumnNames(Table_No_Headers), Table.ColumnNames(Table_W_Headers)}), MissingField.Ignore)

Then you can combine.

--Nate

[slorin]

Table.PromoteHeaders(Table.Combine({Table.DemoteHeaders(Headers),No_Headers}))

Stéphane