MANUAL TABLE REPAIR
Fix a PDF table row split by a line break
When a long label wraps onto a second printed line, text-position extraction can place it in another spreadsheet row. Compare both lines with the source, then use Merge next row only when they belong to the same record. Recheck the numbers before exporting.
Recognize a continuation row
A continuation often has words in the description column and blank quantity or amount cells. That pattern is only a clue. Two genuine records can also contain blanks, and a footnote may follow the last row. Confirm the record boundary in the rendered source page rather than merging every row with an empty amount.
An illustrative before-and-after
This fictional grid illustrates a manual edit; it is not a claim that the detector always returns this exact layout. The second line completes the description and contains no new quantity or amount.
| Stage | Description | Quantity | Amount |
|---|---|---|---|
| Before: row 1 | Office software | 2 | 30.00 |
| Before: row 2 | annual plan | ||
| After: one row | Office software annual plan | 2 | 30.00 |
Merge the continued label
After extraction, place the text caret inside the first of the two rows in the editable grid and click Merge next row. The tool combines cells in corresponding columns and removes the next row. Read every combined cell. If both rows contain amounts, merging can concatenate values rather than add them; do not use this action as a calculation or automatic record matcher.
Check column alignment and totals again
A line-break repair does not fix an incorrect column boundary. Verify each label against its quantity, decimal sign and amount. Remove repeated page headers or footnotes only when the source confirms they are not records. Never add together detail amounts and an already printed total as though both were detail rows.
Know when source links stop matching
A row merge changes the grid structure. Source peek stops providing its original cell coordinates until you extract again; restoring the old row count does not restore the mapping. The source page preview remains the place to compare the edited table. A new extraction replaces the grid, so download any edits you need to keep first.
Download the repaired XLSX
Refresh XLSX after manual edits and open the downloaded workbook to compare complete rows. Editing and merging the current grid do not use another extraction page. Cells remain text; convert numeric columns deliberately only after checking their contents.
Open the extractor and editable grid
Questions
Does Merge next row automatically recognize records?
No. You decide whether the next row is a continuation by comparing the source. The action combines corresponding cells; it does not understand the business meaning of the rows.
Will a merge add two numeric cells?
No. This is a text-grid edit, not arithmetic. Review both rows before merging.
Does editing spend another extraction page?
Row and column edits on the current grid do not spend another page. Starting a new extraction is a separate action.
Does this fix a table stored as an image?
No. The input table must contain selectable text. OCR and automatic cross-page reconstruction are not supported.