Forum Discussion
Need help combining two worksheets
Merge and Append can be done pretty easily through the PQ UI.
For Merge, you just need to make sure your Unique ID's truly match...same type and same string.
For Append, you ideally want both tables to have columns that match. They don't need to match perfectly, but it starts getting a little weird with how columns get ordered if there aren't a perfect match.
You can Merge or Append into an existing query, or create a new one.
I recommend creating a new one, and then changing the queries that are the source of the Merge/Append to a Connection Only that isn't actually loaded.
Thanks, how do I perform step 6, is there an option to Append or manually copy and paste to Worksheet1?
Merge and Append can be done pretty easily through the PQ UI.
For Merge, you just need to make sure your Unique ID's truly match...same type and same string.
For Append, you ideally want both tables to have columns that match. They don't need to match perfectly, but it starts getting a little weird with how columns get ordered if there aren't a perfect match.
You can Merge or Append into an existing query, or create a new one.
I recommend creating a new one, and then changing the queries that are the source of the Merge/Append to a Connection Only that isn't actually loaded.
Hi Rnaval ,
I would take a moment to thank flowingbuckle , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
Thank you very much for your help, all is now working well.
