Apple Numbers · Workbook and canvas essentials · Intermediate
Transpose a Numbers Table and Audit Headers and Rules
Rotate a small report in place, verify every value and formula, and rebuild rather than assume retained sort and filter rules.
Documentation-qualified; independent editorial review and native verification pending · Editorial standards
Outcome and evidence boundary
Change the orientation of an existing report, rather than create a second array using the TRANSPOSE function. This exercise uses a private local workbook and invented counts. No native Numbers execution, save/reopen verification, screenshots or iCloud/iPad parity is claimed.
The official Mac rearrangement page was reached from Apple’s 15.4 Mac guide on 21 October 2026. Its resolved URL is 15.3; it is not evidence of a separately tested 15.4 app build. The unversioned current Mac page corroborates the controls. These are ordinary table-editing operations, not Magic Fill or premium content; Apple distinguishes free creation/editing from Creator Studio features.
Prepare an asymmetric fixture
Create a Blank spreadsheet with a sheet named Orientation and a table named Counts. Set it to exactly four rows and three columns, one header row, one header column and no footer rows. Use no merged cells, categories, pivot tables, forms, charts or sharing in the baseline.
| Cell | Enter |
|---|---|
| A1 | Item |
| B1 | East |
| C1 | West |
| A2 | Folders |
| B2 | 8 |
| C2 | 3 |
| A3 | Labels |
| B3 | 5 |
| C3 | 9 |
| A4 | Combined |
| B4 | =SUM(B2:B3) |
| C4 | =SUM(C2:C3) |
Check B4 is 13 and C4 is 12. The four detail numbers total 25; do not include the two totals when calculating that control. Save Orientation-Baseline.numbers, then work in a separately saved copy, Orientation-Working.numbers. Keep the baseline untouched.
Rotate and inspect the complete result
Select the table, then choose Table > Transpose Rows and Columns. Apple documents that headers exchange roles, row/column dimensions reset, and footer rows become rightmost columns. Formula updates can produce warnings. The page warns about discarded sort/filter rules and unlinking a form if the resulting table is invalid as a form. Audit rules explicitly rather than assuming retention or universal loss for every table. A pivot-source table or a table in a shared spreadsheet cannot be transposed. These documented restrictions are not native test results.
The expected coordinate mapping for this fixture is:
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Folders | Labels | Combined |
| 2 | East | 8 | 5 | 13 |
| 3 | West | 3 | 9 | 12 |
There should be three rows and four columns, with one header row and one header column. Inspect every cell. In particular, B2 must remain 8, C2 must be 5, B3 must be 3 and C3 must be 9. A square or symmetric dataset would conceal some orientation mistakes; these deliberately unequal numbers do not.
Inspect D2 and D3 in the formula editor. They should calculate the two entries in their own row, not retain a range that includes a different label or total. If warnings appear, stop and inspect them. Do not replace formulas with displayed constants merely to make the checks pass.
Prove the formulas remain live
Change B2 from 8 to 10. D2 should become 15; D3 must remain 12. Restore 8 and confirm 13 and 12. Change C3 from 9 to 0: D3 should become 3 while D2 remains 13. Restore 9. These checks distinguish live formulas from accidental snapshots.
Save and reopen the working copy. Recheck the 3-by-4 shape, labels, four details and both formulas. Persistence is a reader acceptance test, not something executed by this author.
Audit rules and a footer in separate copies
Use another copy for rules. Following the existing sort/filter lesson, give a fresh baseline copy a filter East greater than 6, so Folders and Combined are visible while Labels is hidden. Record the actual rule and visible rows before transposing. Afterwards inspect the filter controls and all cells, rather than treating the previous visible subset as the complete dataset. Rebuild any desired rule for the new column meanings. Do not overwrite the baseline.
For a footer test, use a fresh baseline copy and designate its fourth row as a footer before transposing. Expected values remain the same; the Combined values should occupy the rightmost column. Inspect the resulting table roles rather than calling that column a footer row.
If the command is unavailable, investigate the documented restrictions rather than disconnecting a real shared workbook or deleting a pivot table. Returning to the preserved local fixture is safer. For recovery, reopen the baseline; reversing orientation is not this lesson’s guarantee that every discarded rule, dimension or complex formula will be restored.
Setup references
Apple documents creating a spreadsheet, table rows and headers, and saving a separate copy. Keep the native .numbers master; no export-parity result is asserted.