Group rows in a table

[This documentation is for preview only, and is subject to change in later releases.]

You can group the values in a number of rows into a single value by grouping the rows based upon the values in one or more columns. For more information about how to group rows, see the Combine data from multiple data sources tutorial.

Data Explorer has two types of Group By operations: aggregate a column based on an Aggregate Function or perform a Row Operation.

I want to

Aggregate a column using an Aggregate Function

In the Group By dialog box, select Sum, Average, Min, Max, First, or Last as the Operation.

Top of Page Top of Page

Perform a Row Operation

In the Group By dialog box, select Count Rows, First Row, Last Row, or All Rows as the Operation.

Group rows by ProductID and Year

Top of Page Top of Page

Group by one or more columns

  1. Right-click the column header to group on.
  2. In the column context menu, select Group By.
  3. In the Group By dialog box:
    1. In the New column name textbox, enter a group by name.
    2. In the Operation drop-down, select an Aggregate Function or Row Operation.
    3. To aggregate a column, select the column to perform the Aggregate Operation on from the Column drop-down. A Row Operation does not require a Column since data is grouped based on table rows.
  4. To group on multiple columns, click the + button, and repeat step 3.
  5. To remove a Group By operations, click the Delete step button.
  6. Click OK.

Top of Page Top of Page

 
 
Applies to:
Excel 2013