To group project report rows in Numbers on a Mac, add a category using a column that already labels each row—such as phase, team, or workstream. Numbers groups rows with shared values, and you can add a subcategory or summary calculation to make the report easier to scan. If the category does not exist in your data, you can group selected rows manually.

Prepare the project table

Use one row per project item and a header row that names each column, for example: Task, Phase, Owner, Status, and Hours. Choose the column that best answers the report’s main question. Grouping by Phase helps compare work across stages; grouping by Owner helps review assignments. This is a practical choice based on the report’s purpose, not a special Numbers setting.

Before grouping, check that category values are consistent. For example, “Planning” and “Plan” will be treated as different values because Numbers groups rows by shared values in the source column. Correct spelling or naming differences in that column first so the resulting groups match your intended categories. (This follows from Apple’s description of groups being based on shared values in the source column.) Add, edit, or delete categories in Numbers on Mac

Add a category from a column

  1. Open the spreadsheet and click the project table.
  2. In the toolbar, click Add Category, then choose the column to group by, such as Phase.
  3. To create another level, click Add Category again and choose another column, such as Owner.

Numbers creates groups from matching values and displays a summary row for each group. A table can have one main category and up to four subcategories. For a compact report, start with one category; add a subcategory only when readers need that extra breakdown. Apple’s category guide

Group rows when there is no category column

If the grouping is unique to the report and you do not want to add a field such as “Report group” to the project data, select the rows you want to group. Move the pointer over a row number in the selection, click the arrow that appears, then choose Create Group for Selected Rows. Numbers creates two groups: the selected rows and the rows not selected. If the table has no existing categories, Numbers adds a source column called Category 1; the groups initially use placeholder names that you can rename. Apple’s instructions for creating categories

This method is useful for an ad hoc report grouping, but a real category column is easier to maintain as project items change: each row carries its own label. That recommendation is an editorial inference from the two documented workflows.

Add totals or counts for the report

To show a roll-up, click an empty cell in a group’s summary row, click the Summary Action menu button, and choose a function such as Sum, Count, or Average. For example, add Sum in the Hours column to total hours by phase, or Count in the Task column to count listed tasks. The same function is added to other groups at that level, making the figures comparable. Add calculations to category groups in Numbers on Mac

If a summary is unnecessary, leave the summary cells empty. A group name and its rows may be enough for a status report. You can collapse or expand a group with the disclosure triangle on its summary row, and hide the category’s source column in the Categories section of the Organize sidebar while keeping the grouping active. Modify category groups in Numbers on Mac Add, edit, or delete categories in Numbers on Mac

Reorder groups and check the result

To change the order of groups manually, select a group’s summary row and drag the empty square to the left of its name above or below another group. To sort groups by their names or by a summary value, use the arrow beside the group-name column or the relevant column and choose a Sort Groups or Sort Summaries option. Ordinary sorting of a data column sorts rows within their category groups. Modify category groups in Numbers on Mac Alphabetize or sort table data in Numbers on Mac

Before sharing the report, expand the groups and confirm that each item appears under the intended label and that any totals use the right column. To return to the ungrouped view, select the table, open Categories in the Organize sidebar, and turn categories off; Apple says the data remains and can be regrouped after edits. Add, edit, or delete categories in Numbers on Mac

When to use a pivot table instead

Categories are a direct way to organize the original project table. Choose a pivot table when you need a separate summary that combines row and column dimensions or calculates values from source data. A pivot table is a distinct table based on another table; adding or changing source data requires refreshing it to show updates. Intro to pivot tables in Numbers on Mac Create a pivot table in Numbers on Mac

For a straightforward project report organized by one field—such as phase, owner, or status—categorizing the existing table is usually the shorter path. Use a pivot table when the report needs a separate cross-tabulated summary.

Sources