Excel 2019 Bible

Chapter 38: Introducing Power Query

38

FIGURE 38.14

Right-click any column to see the column-level actions that you can use to transform the data.

TABLE 38.1 Column-Level Actions

Action

Purpose

Available with

Multiple Columns?

Remove Remove the selected column from the Power Query data. Yes

Remove Other

Columns

Remove all nonselected columns from the Power Query

data.

Yes

Duplicate

Column

Create a duplicate of the selected column as a new col-

umn placed at the far right of the table. The name given

to the new column is Copy of X, where X is the name of

the original column.

No

Add Column

From Examples

Create a custom column that combines data from other

columns based on a few examples that you provide. Like

the Flash Fill feature in Excel, Power Query’s smart detec-

tion logic infers transformation logic based on your

examples and then applies that logic to fill the new

column.

Yes

Remove

Duplicates

Remove all rows from the selected column where the val-

ues duplicate earlier values. The row with the first occur-

rence of a value is not removed.

Yes

Continues