Forum Discussion
Solved
More efficient multiple merge query
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 quer...
let
source={query1,query2,query3},
custom1=Table.Transpose(Table.DemoteHeaders(Table.Combine(List.Transform(source,each Table.PromoteHeaders(Table.Transpose(_)))))
in
custom1
let
source={query1,query2,query3},
custom1=Table.Transpose(Table.DemoteHeaders(Table.Combine(List.Transform(source,each Table.PromoteHeaders(Table.Transpose(_)))))
in
custom1