Use Merge Tables through 3 how-to topics, including opening the entry, running the first merge, and re-merging results; choose a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Open the Merge Tables entry | Free |
| 2 | 2. Merge multiple worksheets for the first time | Free |
| 3 | 3. Re-merge and refresh results | Free |
How-to Guide
1. Open the Merge Tables entry
Entry path: Data tab → Merge Tables button
- Open a WPS Spreadsheet online collaboration document.
- Click the Data tab at the top.
- Find the Merge Tables button on the right side of the toolbar.
- Click the button to view the two commands in the drop-down menu: Merge Tables and Re-merge.
Success Criteria
- Interface result: You can see the Merge Tables button and its drop-down menu.
- Next action: You can continue with either the first merge or a re-merge.
Tips While Using
- Common mistake: If you are not in a spreadsheet document, the entry may not appear.
- Environment note: Keep the network stable in online collaboration scenarios.
2. Merge multiple worksheets for the first time
Entry path: Data tab → Merge Tables button → Merge Tables
- Click Merge Tables to open the Merge Worksheets dialog box.
- Click the Select... link in the upper-right corner, then choose one or more worksheets in the file picker.
- Set the merge options as needed, including Worksheet contains header, Header row count, Remove duplicate rows, Merge to, Indicate data source, and Auto-update data.
- Choose to output the result to a New Worksheet or another target location.
- Click Start Merge to run the merge.
Success Criteria
- Interface result: A merged result sheet is created.
- Next action: You can continue reviewing, editing, or saving the merged data.
Tips While Using
- Common mistake: If source worksheets use very different column structures, the merged result may become misaligned.
- Environment note: In collaborative work, confirm that source sheets are updated before starting the merge.
3. Re-merge and refresh results
Entry path: Data tab → Merge Tables button → Re-merge
- After source worksheet data changes, open the result sheet that you want to refresh.
- Click the Merge Tables button on the Data tab.
- Select Re-merge from the drop-down menu.
- Wait for the result to refresh with the previous merge settings.
Success Criteria
- Interface result: The result sheet updates to the latest data state.
- Next action: You can continue checking the refreshed result without selecting sources and options again.
Tips While Using
- Common mistake: If the previous merge was not configured correctly, Re-merge will still follow those earlier settings.
- Environment note: If the source sheets changed a lot, review duplicate rows and header handling again after the refresh.