Common questions about Merge Tables usually fall into 3 areas: membership access, merge results, and data preparation; this section answers 4 frequent questions.
FAQ
Why can I see Merge Tables but not use it right away?
- Check whether the signed-in WPS account already has an active membership.
- Confirm that the merge method you selected is a membership feature.
- If the account status changed recently, sign out and sign in again before retrying.
What should I check before merging tables?
- Check whether the field order is consistent across worksheets or workbooks.
- Decide whether header rows should be kept to avoid repeated headers in the result.
- If you plan to match data by the same column content, make sure the matching column is complete and formatted consistently.
What result do I usually get after merging?
- Depending on the method you choose, WPS creates a new result worksheet or a new result workbook.
- You can continue to analyze, filter, or summarize the merged data afterward.
- It is a good idea to save the result separately from the original files.
What can I do if merging becomes slow with a lot of data?
- Close files that are not needed for the current task.
- Remove unrelated worksheets or unnecessary data before starting the merge.
- Wait for the current merge to finish before starting another batch operation.
Glossary
| Term | Definition |
|---|---|
| Worksheet | A single sheet inside a workbook that stores one set of spreadsheet data. |
| Workbook | A spreadsheet file that can contain one or more worksheets. |
| Header row | The top row that labels fields or columns and may need special handling during merging. |
| Same-name worksheet | Worksheets in different workbooks that share the same sheet name and can be consolidated together. |