Adding Rows in Numbers Dependent on Column Info

There is no way I know of to automatically add a blank row based on a value in a cell. But why would you want to do that anyway? In general it is best to keep your data in a consistent table format.

If your goal is to calculate subtotals, averages, counts or whatever from your data then you can use the SUMIF, SUMIFS, COUNT, COUNTIFS functions, or even easier, the built-in functionalities in Numbers that do this without you having to enter a formula.

A. Using the Categories functionality:

B. Using the Pivot Table functionality.

Click in table, then from menu choose Organize > Create Pivot Table > On Current Sheet, and drag from the Source Data box to the Rows and Values boxes as shown ).

Click the circled i ⓘ to see all the various options you have with Pivot Tables. And if you change or add to the data on which your Pivot Table(s) are based just "refresh" by going in the menu to Organize > Refresh Pivot Table.

SG

Your link was missing but I found the page your example table came from.

In Excel, if you select multiple rows (click the first, command-click the others) then insert a full row, it will insert a single row above each of the rows you selected. Not in Numbers. In Numbers, it converts your selection into a single contiguous range spanning from the top of your selected rows down to the bottom one and when you add rows above, it will insert all the new rows above the topmost selected row. While there is a good purpose for that (it allows you to quickly insert multiple rows in one place) it would be nice if they kept "Add row above" and "Add row below" active when multiple rows are selected so you could also do it the way Excel does. If there is a way to do it the Excel way, I am overlooking it.

Time for a feature request? Numbers/Provide Numbers Feedback.

Or it could be done with an AppleScript.

Still not quite sure what you mean. To insert row anywhere just choose Add Row Below or Add Row Above from the contextual menu that appears when you click the "v" to the right the row number on the left of the table.

You have to do this manually. Spreadsheets don't add rows or columns automatically based on values in cells (except with perhaps a script, which would be more effort than a quick manual operation).

SG

MC2016 wrote:

My table is strictly information in personnel.

If you don't need the subtotals then just use Category without them.

With one click (less than a second) and you have something good for presentation. No struggles needed.

SG

What do you mean by "add a row dependent on that"?

SG