Outline (group) data in a worksheet - Microsoft Support
Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.
Group or ungroup data in a PivotTable - Microsoft Support
In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Group rows of data (Power Query) - Microsoft Support
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.
GROUPBY function - Microsoft Support
The GROUPBY function in Excel allows you to create a summary of your data via a formula.
Use a screen reader to group or ungroup data in a PivotTable in …
Group or ungroup data in a PivotTable in Excel using your screen reader and keyboard.
Group worksheets - Microsoft Support
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 …
Sort data in a range or table in Excel - Microsoft Support
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.
Insert subtotals in a list of data in a worksheet - Microsoft Support
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 …
Create a grouped or summary report - Microsoft Support
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 …
Combine text from two or more cells into one cell in Microsoft Excel
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.