Power QueryExercises

Expand

Turning a nested table, record or list column into ordinary columns or rows.

Expanding a table column can add rows (one per nested row); expanding a record column adds columns only; expanding a list column adds rows. Selecting just the fields you need keeps the query fast, and naming them avoids clashes with existing columns.

In the Power Query editor

The two-arrow icon in the header of a nested column opens the expand menu.

Learn more

Related functions

Practise it

Related terms