Job spreadsheet-flatten-merged-cell-report · revised 11 October 2026
Turn a merged-cell Excel report into a flat table you can sort and pivot
One sheet of merged cells, repeated headings and subtotal rows becomes a flat table with one row per record, whose row count and totals reconcile with the original.
You might be seeing
- Excel refuses to sort a column and mentions merged cells
- Group names such as a region or department appear once above several rows instead of on every row
No passwords, keys, card details or admin invites needed to start.
What usually happened
A sheet laid out for printing uses merged cells for group labels, repeated heading blocks, blank spacer rows and subtotal lines. Excel does not sort a column that contains merged cells, filters treat the layout as several tables, and a PivotTable wants one header row with no merged cells. The data cannot be analysed without re-typing it, and re-typing loses track of which records belong to which group.
Who it’s for: An office manager, administrator or small-business owner who inherited a report laid out for printing and now needs to sort it, filter it or summarise it.
Usually starts when: Sorting the report fails, filters hide records, or a pivot summary will not build because of merged group labels and subtotal rows.
The result: A new sheet holds one row per record under a single header row with no merged cells, each group label repeated on every row it applied to, and the record count and each column total reconcile with the original under rules written down beforehand.
Check whether this job fits
Answer these without sending the report. Nothing is submitted unless you choose to contact us.
Checks you can run yourself
Find the merged cells
In Excel choose Home, Find & Select, Find, then Format, Alignment, tick Merge cells, and select Find All. Do not unmerge anything yet.
Look for: The list shows every merged cell. A few means a quick tidy; hundreds mean a layout built around merging, which this job handles.
What you get
- A flat data sheet with one header row and one record per row
- A reconciliation sheet: original rows, records, removed rows by type, and each numeric column total before and after
- A short note of the rules used for labels, subtotals and unusual rows
Included
- One sheet of up to 5,000 data rows in one repeating layout, delivered as a new sheet in a new workbook
- Unmerge group labels and repeat each one on every row it covers, using a rule you confirm for each kind of label
- Remove spacer rows, repeated heading rows and subtotal rows from the data, but list each removed row by type in a reconciliation
- Make each column hold one kind of data, such as text, number or date, and report cells that do not fit
Not included
- Correcting figures or formulas in the original; that is a different job
- Combining several different report layouts into one table
- Building a PivotTable, chart or dashboard from the result
- Deciding which group a label belongs to when you cannot say
- Personal data of any kind, or confidential data in the first enquiry
How we know it’s done
Agreed with you before work starts. Each check produces evidence you keep.
The flat sheet has a single header row, and a search for merged cells in it finds none.
Evidence: A screenshot or note of the merged-cell search on the flat sheet returning no cells.
The number of original rows equals the number of records plus the number of removed rows, and every removed row is listed once with its type (spacer, repeated heading or subtotal).
Evidence: The reconciliation sheet with counts and the list of removed rows.
For each numeric column, the total of the records equals the total of the original record rows, and each subtotal in the original equals the recomputed subtotal or the difference is listed.
Evidence: The reconciliation sheet showing each column total before and after, and the subtotal comparison.
In an agreed sample of at least 20 records, every group label on the flat sheet equals the label that covers that record in the original.
Evidence: The sample sheet listing record, original label, flat-sheet label and result.
Sign-off. You sort and filter the flat sheet yourself, check a few records against the original and sign off in writing. Payment follows sign-off.
If it fails. If the agreed checks do not pass, you do not pay for this fixed scope. If the layout turns out to be inconsistent or the labels cannot be assigned without guessing, we explain why, hand back what we have and agree whether to re-quote or stop. No surprise work.
When it fits, and when we stop
It fits when
- The layout repeats consistently, and you can say which rows each merged label covers
- You are allowed to share the file with a contractor, and it holds no personal data about individuals
- A named person can answer questions about unusual rows and sign off
We stop and tell you if
- The layout changes from block to block so that no single rule covers it, and you do not want it re-quoted
- A merged label could belong to the rows above or the rows below and nobody can say which
- The numbers in the original do not add up and you want us to decide which figures are right
What could go wrong
The original sheet is never changed. The flat table is a new sheet in a new workbook; delete it if you do not want it.
Scroll the table sideways to read it all.
| Risk | How we handle it |
|---|---|
| A group label is repeated onto the wrong rows. | The covering rule for each label type is agreed first, and the sample check compares labels record by record. |
| A subtotal row is kept as data, or a record is dropped as a subtotal. | Removed rows are listed by type, and original rows must equal records plus removed rows. |
| Cells that were merged long ago have already lost the values they held, so some values are missing before we see the file. | Excel keeps only the upper-left cell when cells are merged. We report empty cells we find, but cannot recover data that was deleted before we received the file. |
A reviewer who did not build the table compares a sample of records with the original and re-checks the totals. You confirm the group labels on a sample and sign off.
How we deliver
We arrange the work and independent review, then show you the result against the agreed checks. You keep authority over your systems.
- Agree the layout, the rule for each kind of label and subtotal row, and the reconciliation checks in writing
- Copy the sheet to a working file and list every merged range, heading row, spacer row and subtotal row
- Unmerge and repeat each label on every row it covers; remove the non-record rows into the reconciliation list
- Set each column to one data type and report cells that do not fit
- Reconcile record counts and column totals against the original
- Have an independent reviewer check a sample of records against the original, then hand over
This is a one-off job, not a subscription. We confirm eligibility, the total price, a start window and a delivery date before you accept. Work starts only after the agreed files, the secure handling route and the acceptance checks are written down. An enquiry creates no charge or booking. We give no legal, medical, financial or tax advice.
Need to keep it working?
If the same printed-style report arrives every period, the flattening can be included in a recurring report pack. That is a separate quoted agreement.
Ongoing work is separately scoped and quoted: no monitoring, response-time guarantee or automatic subscription is included in this job.
Explore an ongoing engineering lane, or mention the responsibility you need in your enquiry.
What you can check
This is a new service. We have not delivered this job for a client yet.
Other ways to get this done
- For a small sheet you can unmerge the cells yourself, then fill each label down. Excel moves a merged cell's content to the left cell when you unmerge, so labels need copying down. support.microsoft.com
- If you can still ask whoever produces the report, ask for a plain data export without the print layout.
Questions
Will the flat table change my numbers?
No. We do not alter the figures. We repeat labels, remove layout rows, and show that counts and totals reconcile with the original.
What happens to the subtotal rows?
They leave the data table, because they would double-count in a pivot or filter. Each one is listed in the reconciliation and compared with a recomputed subtotal.
Can you build the pivot table or dashboard too?
Not under this price. The result is a clean table ready for that. Building summaries would be a separate scope.
Send an enquiry
Send us
- A description of the layout (for example "region in a merged cell, then product rows, then a subtotal line") and the approximate number of rows
- Whether the sheet has formulas, and the column totals you expect to match
- An invented mock-up of two groups; no real report in the first enquiry
Later, once you agree
- The workbook through the secure handover route we agree in writing before any file moves, with confirmation that it holds no personal data and that you may share it
- Your decision for each kind of label and subtotal row
- A named person to answer questions about unusual rows
You keep ownership of every file we work on and of what we return. No upload portal exists yet, and the first enquiry never includes documents: send a description, counts and an invented or redacted sample only. Work can start only after we have agreed with you, in writing, a secure way to hand the files over, who may see them, how long we keep them and how we delete them. If we cannot offer a way you are comfortable with, we decline and nothing is charged. Files may be handled by automated software, including services run by other companies, and we tell you which in writing before any file moves. We work on copies, never on your only original, and we do not send, publish or contact anyone for you.
Email fallback: open your mail app
If website submission is unavailable, review and send the fallback email yourself. An email fallback is not a website receipt. Or write to hello@syntheticindustry.ai with “spreadsheet-flatten-merged-cell-report” as the subject.