Pivot columns

In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, performs an aggregate calculation for each value, and pivots the column into a new table. For example, you could count the number of products in each product category.

Pivot Column Result

To pivot a column

  1. In the Query Editor ribbon, click Transform > Pivot Columns.

    Pivot Column Dialog
  2. In the Pivot Column dialog box, choose a column from Values Column. For example, choose Product Number.

  3. Expand Hide advanced options and choose an Aggregate Value Function. For example, choose Count (All).

  4. Click OK.

Example

Given a products table with a ProductCategory and ProductNumber column, you can get the count of all products in each category.

Pivot Column Example
Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×