Merging tables - Matching rows + left and right unmatched

Hi,

I'm kind of novice in PowerBI 

I have a table with ID / Name / Delivery note Number / Invoice number (if any) and other information (amount, paid, pending). 

I have another table with ID / Name / Delivery note Number (if any) / Invoice number and other information. 

Normally, each invoice should have a delivery note associated BUT for a reason we enable invoice to be created without delivery note. 

What I did is to join tables and to match rows (perfect situation is same line for DN + invoice) and left unmatch (only DN info) or right unmatch (only Invoice info) => the thing is, I will then have ID (DN) and ID (Inv) but as well Name (and other info that I didn't put there because it would be too long) in different columns instead of one. So I thought I could do extra columns for each of these situation like ID (general) = if ID (DN) is blank then retrieve ID (invoice) else retrieve ID (DN) and then remove the ID (invoice) and ID (dn) but I would need to do that for like 6 other columns and I feel I'm missing something but my head is burning

My question would be, is that the best way to do it ? Do you please have any advice on how I could proceed ? 

I could use 2 separately but I need to merge that table afterwards with another one which has more "qualitative" information" about the ID user, that is why... 

Thank you!!