Fable
The ledger keeper reconnected the scattered cells into a table
The Jiangnan accounting house received a batch of old merchant ledgers. The pages were yellowed, the ink lines broken and intermittent, many numbers written in grids, and some goods names continued across pages. The new apprentice copied every character into one long string, thinking that if all the text was there, the organizing was done.
The bookkeeper brought it over for reconciliation and immediately spotted something wrong. March salt prices had been appended to February product names, notes were treated as quantities, and the same row across pages was split into two entries. Nothing was missing, but the table's structure had fallen apart.
The apprentice's first repair was to number the copied text in order of appearance. The order was clear, but he still did not know which number belonged to which column, which cells were merged, or which horizontal line was merely decoration. The account book looked complete but could not be calculated.
The old ledger master had him first find the headers, row boundaries, column boundaries and merged cells, then restore each cell's position, text and ownership relationships. Places that were unclear had to be marked as doubtful points, not guessed as definite numbers.
They encountered a cross-page cargo list again. The old ledger master did not treat the second page as a new table, but followed the cargo name, number and subtotal back to the previous page. Remarks, units and amounts each returned to their proper place, and only then could the accounts be inventoried again.
The apprentice finally understood that organizing a table is not about moving the characters out, but about extracting the row-column relationships, the meaning of headers, cell boundaries, and cross-page connections all together. Only when the structure returns does the ledger turn from scattered characters into usable data.
The accounting house later kept samples for each extraction. If a column of numbers had insufficient confidence, a reviewer would look at the original page; if a header spanned two rows, the merge rule was recorded. Without these markers, errors become harder to find in later summaries.
The shopkeeper recalculated the accounts using the restored table and only then discovered an old debt hidden in a cross-page subtotal. The apprentice was finally convinced: the value of a table lies in relationships, not isolated text. Once rows, columns, hierarchy and provenance are preserved, later people dare to keep using it. Later, when the accounting house received new ledgers, the apprentice first looked at the lines, then the cells, then the characters. With the order changed, there were far fewer errors. Text is only the surface; whether the skeleton of the table can be restored determines whether later calculations can hold. Once the structure returned, the old pages became accounts that could be trusted and calculated again. Later the accounting house preferred to mark the structure clearly a little more slowly rather than hand over a string of text that could not be reconciled. This patience bought the credibility of all subsequent calculations.