Unmerge & Fill Cells
How to use
1. Upload the XLSX file with merged cells. 2. Choose the sheets, columns and start row, then check the filled values (for example, the department name) in the preview. 3. Download the result as an XLSX file, compare it with the original, and use it for filtering, sorting, and pivot tables.
Example
- Input: a status table with department names and dates merged vertically — a table where filtering shows only the first row of each group - Result: a 30-row table with merges removed and blanks filled with the value above — every row has a value, so sorting, filtering, and pivots all work
View details
- Limits
- - Only the columns you choose are processed, and blank separator rows and formula-only rows are skipped. - Blanks that were supposed to stay empty can get filled with the value above. After converting, check the rows that originally had no value. - Formatting such as cell colors and borders may not carry over to the result. This is a value-focused conversion.
- Cost type
- Free
Comments
Be the first to comment.