When using Merge Tables, the most common questions focus on duplicate data, inconsistent column structures, and result updates; this FAQ includes 3 common answers.
FAQ
What should I do if duplicate data appears after merging?
- Open the Merge Worksheets dialog box again.
- Select the Remove duplicate rows option.
- Run the merge again and check whether only the needed rows remain in the result sheet.
Can I merge worksheets if their column order is different?
- Yes, but it is better to check the column names and order in each source worksheet first.
- Align the worksheet structures as much as possible before merging again.
- After the merge, review the result carefully for possible misalignment.
Will the result update automatically after source worksheets change in collaboration mode?
- If Auto-update data was enabled during the first merge, the result can sync with source changes.
- If that option was not enabled, use Re-merge to refresh the result manually.
- For recurring reports, it is helpful to enable automatic updates during the first merge.
Glossary
| Term | Definition |
|---|---|
| Merge Tables | A feature that combines data from multiple worksheets or documents into one result sheet. |
| Re-merge | An action that refreshes the result sheet by using the previous merge settings. |
| Remove duplicate rows | An option that identifies and removes repeated records based on full-row content during the merge process. |