Our response to this question was as follows:
Regarding your question, there are two extra empty columns when you append the two queries, the cause of this problem is that the data model matches the data in the two queries using the column name.
So, the data model understands that there is a column called “Work Date” in the first query, and there is another one on the second query called the exact same name, the data will be appended. Otherwise, even if the difference between the names is a space, excel will create two columns for the two values as there are two different names.
In your case, Excel didn’t understand that both columns in the two queries were the same, as the names of the columns weren’t matching. The simple and easy solution for this problem is to copy the columns names from one table to another before creating the queries to make sure that they will match later when you merge or append them.
So, I basically took your sheet and copied the headers of the two columns that were causing the problem and pasted them from one table to another, after that I recreated the queries and added both to the data model, then I appended them and everything looked good.
No empty columns and all data is correct. The corrected sheet after the edit is attached to this mail, so check it and reply to this mail if there are any other problems.