How to fill blank cells with the value above
✓ Verified in LibreOffice 25.8.7.3Un-merge pivot-style exports where the group label appears once and the rows below are blank.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =IF(A2="",B1,A2) | In a helper column B (formula shown for B2, referencing B1 above), fill down, then Paste Special → Values over A. |
| Google Sheets | =IF(A2="",B1,A2) | Identical helper-column pattern. |
| LibreOffice Calc | =IF(A2="",B1,A2) | Identical. |
How it works
The helper column carries values forward: each row shows its own A-value when present, otherwise it repeats the helper cell ABOVE — which already holds the last real label. Filled down, every blank inherits the nearest label upward (the verification shows one link of that chain). Finish by copying the helper over the original as values. Excel's non-formula route: select the column, Go To Special → Blanks, type = the-cell-above, then Ctrl+Enter fills every blank at once.
Verified, not just documented
We ran =IF(A3="",B2,A3) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned Widgets — exactly the expected result. Every formula here is confirmed by actually executing it.