Excel 2019 Bible

Chapter 39: Transforming Data with Power Query

39

FIGURE 39.2

Removing duplicate records

If you made a mistake and removed duplicates based on the wrong set of columns, don’t

worry. You can always use the Query Settings pane to delete that step. Right-click the

Removed Duplicates step and select Delete (see Figure 39.3).

FIGURE 39.3

Undo the removal of records by deleting the Removed Duplicates step.

Don’t see a Query Settings pane? Select View ➪ Query Settings to activate the Query Settings pane.