Hi Steven,

You can load the query results to any sheet you like.  When you click on Close & Load To you can choose to load to an Existing worksheet.

However, having your source table and your query result table on the same sheet can cause issues if the source table grows in size and overlaps the query result.  If the number of columns stays the same, you can have both tables side by side, with a column of space between them.

Regards

Phil

So, I am confused, and I apologize in advance.

When I merge my power query table result with another table to add two descriptive columns "code description" and "code categories" at the end of my original power query.  I need to create a new Query result or spreadsheet and I can't simply merge and replace. If that is the case, if I am adding descriptions from several different codes and i need to do 3 merges, I have to create new data tables (Spreadsheets) for each and then only keep the last merged dataset for my pivot tables.  So, every time I do a merge of two queries, i will have to update all my pivot table sources.

Does that question make sense?  Am I being stupid to think I can just keep merging and replacing my original query.  I already built my pivot tables and I am now adding descriptions via merges and I am trying to avoid changing the sources for all the pivot tables - unless there is an easy way to change the source across all pivot tables globally?

When I goto the new data sheet and hit Load to:  the "Select where the data should be loaded" section is greyed out and not accessible.  See my screen shot attachment.

When you do a merge I don't see an option function to load over the current power query

I am very new (a couple of days), so forgive me if this is just a stupid question.

Thanks in advance.

Hi Steven,

It's hard to understand what you are trying to do without seeing your files.

Can you please attach some sample files including the queries.

regards

Phil

Hi Philip, 

I apologize for the confusion and I am sure a little frustration with my question.

If I can simplify my question - can I do a merge and have the data placed in the original worksheet or do I have to create a new merge spreadsheet everytime.

In the screenshots attached - I have a Data table (spreadsheet) and a Code Descriptions Tab

I merge them and the merge result (Merge2) is now a new dataset. 

------

Can I merge the data table (spreadsheet) and the code description tab and have the result end up being in the original data table (spreadsheet)?  If not, how do I create a new merge data table after the merge is processed?

Screen shots attached.

I also attached my xls spreadsheet - the two tabs I am merging our Data table (status Code) and Code descriptions (Code) and then I would like the merge to end up in the Data Table so I don't have to change the source of all my pivots.  I am adding two additional description columns (description and category from the code description tab).

I hope this makes more sense.

Hello Philip,

You can ignore my last post - I just decided to change all my source data to the new merge and left it at that.

Thanks for your help and understanding.

Best regards.

Steve

No problem.  Glad you got it sorted out.