How to combine 2 tables into 1 new table?

[ericbi]

Hi, 

I have 2 tables ( table 1 & 2)  Receivable log and Payable Log.  I would like to combine the 2 tables into 1 ( T3), some columns in T1 is not in T2, so in the T3 just need to keep that column and leave the column from T2 in blank. 

also how to show the T3 in the dashboard or report? 

[jthomson · Accepted solution]

You just append the tables in Power Query and it'll do almost everything you want in T3, for the last column you'd just need to add a custom column with the function if [Debtor]="" then [Creditor] else [Debtor]