WPS Merge Tables on macOS FAQ

Q: What should I do if duplicate rows appear after merging?

Open the Merge Worksheets dialog box again. Select Remove duplicate rows in the settings. Run the merge again, or use Re-merge to refresh the result. If duplicates still remain, check whether the rows are fully identical across the whole row.

Q: Will the merged result update automatically when collaborators edit the source worksheets?

If Auto-update data was selected during the first merge, the result can update with source changes. If that option was not selected, use Re-merge to refresh the result manually. For summary sheets that need ongoing synchronization, confirm the auto-update option during the initial setup.

When using WPS Merge Tables, common questions usually involve duplicate rows, column consistency, and result updates; this FAQ includes 3 common questions and a glossary.

FAQ

What should I do if duplicate rows appear after merging?

Open the Merge Worksheets dialog box again.
Select Remove duplicate rows in the settings.
Run the merge again, or use Re-merge to refresh the result.
If duplicates still remain, check whether the rows are fully identical across the whole row.

Can I merge worksheets if their column order is different?

You can still run the merge, but it is recommended to check the column names and order first.
Standardize the column structure across source worksheets before merging when possible.
After the merge, review key fields to confirm that no data is misaligned.

Will the merged result update automatically when collaborators edit the source worksheets?

If Auto-update data was selected during the first merge, the result can update with source changes.
If that option was not selected, use Re-merge to refresh the result manually.
For summary sheets that need ongoing synchronization, confirm the auto-update option during the initial setup.

Glossary

Term	Definition
Merge Tables	A feature that consolidates data from multiple worksheets or documents into one worksheet.
Re-merge	An action that refreshes the consolidated result by using the previous merge settings again.
Remove duplicate rows	An option that keeps only the first occurrence when fully duplicated rows are found during merging.
Mark data source	An option that labels where each row came from in the merged result.
Auto-update data	An option that keeps the merged result synchronized when the source data changes.