When using WPS Merge Tables, the most common questions focus on duplicate rows, column consistency, and automatic updates; this FAQ covers 3 common questions and solutions.
FAQ
What should I do if duplicate rows appear after merging?
- Open the Merge Worksheets dialog again.
- Turn on Remove duplicate rows in the merge options.
- Run the merge again and check whether the repeated records are removed.
Can I merge worksheets if their column order is different?
- Yes, but it is recommended to check the column names and column order first.
- If the structures differ a lot, standardize the columns before running the merge again.
- After merging, review key fields to confirm that the data is aligned correctly.
Will the merged result update automatically when collaborators edit the source worksheets?
- Turn on Auto-update data during the first merge.
- If that option was not enabled, use Re-merge to refresh the result manually after source changes.
- For ongoing synchronization, enable automatic updates during the initial setup.
Glossary
| Term | Definition |
|---|---|
| Merge Tables | A feature that combines data from multiple worksheets or documents into one result worksheet. |
| Re-merge | An action that refreshes an existing merged result while keeping the previous merge settings. |
| Remove duplicate rows | An option that removes fully repeated rows during the merge process. |
| Indicate data source | An option that marks which source worksheet each record comes from. |
| Auto-update data | A setting that keeps the merged result aligned with changes in the source sheets. |