Combine two tables with similar column headings together

[CCAd]

Hello everyone,

I have various tables loaded in my Power Bi file. I am trying to merge two tables, sales and leases, into one since they have same column headings. Both have a 'Listing ID' column which contains unique values. I tried the 'merge' within PQ but all it does is give me additional columns from the second table. I tried append also but that somehow nullifies the listing IDs of the second table.

Is there a way that I can do this? I did combine the two files in excel but for the sake of ensuring data update, I would prefer to do it from within power bi.

I am pasting snippets of both files below, if that helps. There are hundreds of other columns extending to the right in each table.

Thanks in advance

[AlienSx]

hi @CCAd , Listing ID <> listing id

[CCAd]

sorry mate, didnt quite understand you. if you are referring that i match listing ID columns in each table with each other, i did that too (also renamed both so they are exactly the same). 

Can you dumb down the explanation for me please?

Thanks again

[AlienSx]

PQ is case sensetive so "Listing ID" and "listing id" are not the same animals. 

[CCAd]

Great. Let me give it a shot.

Cheers