More efficient multiple merge query

[Diana2022]

Hello!  I'm using Powerquery to create an Excel table.   I have twelve queries (each which has two columns. The left column is identical row headings for each query) .  The second column of each query I want to merge into a consolidated table in Powerquery.  Is there a more efficient way to write this than this: #powerquery #mergepainful multiple merges

[Diana2022]

Thank you! This runs so much more efficiently.

[wdx223_Daniel · Accepted solution]

let

source={query1,query2,query3},

custom1=Table.Transpose(Table.DemoteHeaders(Table.Combine(List.Transform(source,each Table.PromoteHeaders(Table.Transpose(_)))))

in

custom1