1

I have created a number of power queries. So far I have done them by merging two sources (Merge as new). Now just want to extract from the existing query. I don't need to merge it with another one. I'd like to do some filtering on the query and save it as a new one. When I click on the query and edit (filter) it, it'd update the existing one. I'd like to save the results of my filtering as a new query.

I'm using Excel 2016 (O365). Thanks

Wasteland
  • 4,889
  • 14
  • 45
  • 91

1 Answers1

3

Find your "existing query" in the Queries & Connections pane. Right-click it and choose Reference.

You can also do this in the Power Query Editor window, from the Queries pane.

You will get a new query which picks up from the last step in the "existing query".

Mike Honey
  • 14,523
  • 1
  • 24
  • 40