WPS Merge Tables on Windows FAQ

Last updated:July 20, 2026

When using WPS Merge Tables, 3 common question types come up most often: duplicate data, inconsistent column structures, and collaborative updates; this FAQ includes 3 frequent questions and a glossary.

FAQ

What should I do if the merged result contains duplicate data?

  1. Open the Merge Worksheets dialog box again.
  2. Turn on Remove duplicate rows in the merge options.
  3. Run the merge again and check whether only the first duplicate record is kept.

Can I still merge worksheets if the source sheets use different column orders?

  1. Yes, but it is recommended to check the column names and column order in each source worksheet first.
  2. If the structures differ a lot, align the columns before merging.
  3. After the merge, review the result carefully for misaligned data.

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

  1. The result updates automatically only if Data auto update was turned on during the first merge.
  2. If that option was not turned on, use Re-merge to refresh the result manually.
  3. For a summary sheet that needs ongoing sync, enable auto-update during the initial setup.

Glossary

TermDefinition
Merge TablesA feature that combines data from multiple worksheets or documents into one worksheet.
Re-mergeAn action that refreshes an existing merged result with the previous sources and settings.
Remove duplicate rowsAn option that identifies duplicate data rows during merging and keeps only the first record.
Mark data sourceAn option that labels which source worksheet each row comes from in the merged result.
Data auto updateAn option that keeps the merged result updated when the source worksheets change.