see the attached
this is how the data is joined from your 3 sheets
And this is the simple spread sheet
the "sales" sheet is used as the base the other 2 sheets are joined to it -
is this what you wanted
For me, this thread is solved
To be able to do my full outer join, i have used the same datasource types (both in Excel files).