Log In
Register
Home
June 15, 2023
Offline
Hi all,
I'm having an issue with using Power Query to combine 2 Worksheets with identical (similar) data.
I'm trying to get the to combine so I can show the data in a pivot table/ Chart
For some reason when I use Power Query it keeps giving me Null Values and puts all the data from the 2 worksheets on 1 row instead of separate rows.
See attached File.
Thanks,
IKE
Moderators
January 31, 2022
Offline
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.
June 15, 2023
Offline
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
Moderators
January 31, 2022
Offline
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.
1 Guest(s)
