Hi,
I'd like to do a FULL OUTER JOIN of 3 tables in Excel.
Each table has 4 columns - 3 categories (for joining) and one metric column. All the 3 joining columns are the same across the 3 tables.
As MS Query does not support the FULL OUTER JOIN command it can only do this using UNION. There...