Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.

In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.

The GROUPBY function in Excel allows you to create a summary of your data via a formula.

In Power Query, you can group the same values in one or more columns into a single grouped row. You can group a column by using an aggregate function or group by a row.

You can insert one level of subtotals for a group of data as shown in the following example. To sort the column that contains the data you want to group by, select that column, and then on …

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are …

You can create a basic grouped report by using the Report Wizard, you can add grouping and sorting to an existing report, or you can revise grouping and sorting options that have already …

Split data into multiple columns Applies To Sometimes, data is consolidated into one column, such as first name and last name. But you might want separate columns for each. So, you can …

How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.