Combining 3 tables in Power Query without losing any columns

[edwardroa]

Firstly thank you for looking into my query!

I'm struggling to combine 3 tables into 1 tables without losing any columns. I am currently using the "Append Queries" function to combine the 3 tables into the 1 table however when I combine them, instead of using a unique column and adding additional columns onto the end, it loads the 3 tables as 3 separate lines.

For example, below are 3 tables with one column in common across the 3 tables (Unique reference):

Table 1

Table 2

Table 3

Desired Table

I'm sure there must be an easy way however I've not been able to find it yet.

Any guidance would be much appreciated.

Thank you,

Edward

[Adel]

you could use this for example 

You can use List.Generate() to try your loop query and then append the list like:

let
...
TablesToAppend = List.Generate(your loop query),
TablesAppended = Table.Combine(List.Transform(TablesToAppend, each (_))),
...
in
...

[edwardroa]

Hi Adel,

What do you mean by "your loop query" please?

Kind regards,

Edward