Appending two queries together, but in a new separate query

[ScottF]

When I currently append query B to query A, it leaves me with a query A that just has query B values added on to the bottom. What I'm looking to do is to combine query A and query B in a way that would give me a new query C with both A and B values in it, but would then also leave me with a separate query A and query B. I'd really like to keep individual versions of A and B just from an organizational perspective.

I've thought about making a copy of query A and then appending to that, but the problem there is that if I make changes in the original non-appended version of query A, the changes won't be reflected in the copied version that has B appended to it. However, if I make changes to query B, those changes would be reflected in the copied version of A.

So the question is: Is there a way to append/combine two queries into one new query while keeping individual versions of the original two queries? Thanks!

[Sean · Accepted solution]

@ScottF

Get Data => Blank Query => in the Query Editror => in the formula bar type of the newly created Query => type

= Table Name

that will create a copy of Table 1 => then Append as normal

Let me know if this helps.

[ScottF]

That worked! I just opened a blank query and typed in = #"Name of my Query" and it pulled it in there. Thanks for the help @Sean!