Create a Full Outer Join in Excel Power Query

If you wanted to merge two tables together to figure out what records may have "missing', blank or null values in the fields, a full join or full outer join may be the solution for you. The use for this type of join can be for reconciliation or trying to discover what type of values you don't have from one table to another. If you want to see all records from table, look into using the full outer join merge capability in Excel Power Query.