Power Query lets you perform a series of steps to transform your messy Excel data. And if you make a mistake, it’s very easy to Delete Steps Until the End!

Let’s say you’re deep in thought, creating multiple steps, then all of a sudden you realized midway some of the steps were incorrect.

Our sample Power Query steps removes rows from our table, and we want to undo those steps!

Let’s go through the steps in detail:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Let us edit an existing query that we want to modify.

Go to Data > Get & Transform > Show Queries

Delete Steps Until End In Power Query

Double click on your Query to open the Power Query Editor.

Delete Steps Until End In Power Query

 

STEP 2: We want to remove all of the Removal steps in our Query. So we will be deleting Step #3 onwards:

Delete Steps Until End In Power Query

Right click on the Step #3 and select Delete Until End.

Delete Steps Until End In Power Query

 

 

STEP 3:  Click Delete.

Delete Steps Until End In Power Query

The steps are removed, and you can see your data is now restored!

Delete Steps Until End In Power Query

 

How to Delete Steps Until End in Power Query

HELPFUL RESOURCE:

Free Excel Macros & VBA Webinar Training

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin