My Day✳All blog articles ↗

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.

P1 actual: 2 drafts; 1 final
P1 actual: 2 drafts; 1 final

What to do

  1. Identify the row and every header level for each selected column.
  2. Write the complete header chain beside the value, retaining its names.
  3. 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.

Buy My Day for Windows ↗