How To Merge Categories
Part 2 of Creating and Modifying Variables (Video) |
Two or more categories of a question can be merged by dragging and dropping, or, by selecting the categories, right-clicking, and selecting Merge. If you have many similar questions that all need to be merged in the same way, you can achieve this using Modifying Data - Use a Question as a Template for Modifying Other Questions.
There are many other automated methods for merging, which are available if you search for merge in the Online Library.
Large number of values
For numeric data, where there is often a large number of unique values, merging on the table can be impractical and it is easier to use the steps outlined in How to Consolidate Many Categories into a New Pick One Question.