Keep the full header path in a table excerpt
Copy the row identity and complete column-header chain with each value.
A detached number loses meaning when the same lower header appears under different groups. A usable excerpt needs its row identity and the full path from parent header to child header. Check each value against its original cell.
What to do
- Identify the row and every header level for each selected column.
- Write the complete header chain beside the value, retaining its names.
- Read the excerpt alone, then compare it with the original cells.
Example
Fictional table: both “Plan” and “Actual” contain “Drafts” and “Finals”. Row P1 has 2 actual drafts and 1 actual final. Result: “P1 | Actual/drafts: 2 | Actual/finals: 1”. “Drafts: 2” omits the parent group. The excerpt preserves actual values rather than silently relabelling them as planned.
My Day · Windows
Manually save this personal record in My Day.