Excel 2019 Bible

Chapter 38: Introducing Power Query

38

Action

Purpose

Available with

Multiple Columns?

Split Column

(Ribbon only)

Split the value of a single column into two or more col-

umns, based on a number of characters or a given delim-

iter, such as a comma, semicolon, or tab.

No

Merge Column

(Ribbon only)

Merge the values of two or more columns into a single

column that contains a specified delimiter, such as a

comma, semicolon, or tab.

Yes

Understanding table actions

While you’re in the Power Query Editor, Power Query allows you to apply certain actions
to an entire data table. You can see the available table-level actions by clicking the Table
Actions icon, as shown in Figure 38.15.

FIGURE 38.15

Click the Table Actions icon in the upper-left corner of the Power Query Editor Preview pane
to see the table-level actions you can use to transform the data.

Table 38.2 lists the table-level actions and describes the primary purpose of each one.