The query merely combines all tables from the current workbook. The first time you run it, PQ only 'sees' two tables, but when you load the result back to Excel, a third table is created which will be included when you refresh the query. This will create duplicates.

I adjusted the query to filter out the third table after the Source step. Then I also added some proper formatting/data typing and the query seems to do just what you have in mind. Combine the two tables, with data from each on its own row.

If that's not what you had in mind, please come back here and clarify.

The issue is I need Columns F,G, & H to be on Row 3 not Row 2
This is separate data from a separate table than columns B, C, D.

Thanks

The column headers aren't the same. That's why PQ places them in separate columns. Some columns explicitly refer to Technical Service department, others to Customer Service department. You also have Technicians in one department and Specialists in the other. So, these are considered different questions. consider changing this to our Service department.

Then you also have some questions with the same wording in both surveys but with or without a "?". 

So, harmonize the questions and redo the query. See attached.