07 - How to merge row or column categories in cross tables

In some cases you will want to merge categories into larger or more robust categories for your cross tables.

Follow these steps:

1. Select the table(s) and click "Edit", the question editor will show up

a. If you have selected one question, the structure of this will appear.

b. If you have selected more than one question, there will be a tab for each selected question

2. For a single or multiple question, the question will appear with the rows only

    1. Select the response-rows you want to merge
    2. Click on Actions and select "Merge rows".  A new category is created. The categories included in the merged categories are autmatically disabled (un-checked).

This will result in the following:

You can override the new category text. The original categories are automatically unchecked, but you may re-check them if you want to display both the merged and original categories.

Note: The rows in a NUMERIC GRID, i.e. a numeric question with several rows, may NOT be merged in this manner. In that case you should create a “Custom question” using the filter builder.

Note 2: The merge categories is a "logical" OR between all the categories. If you need any other combination, like answerd both categories, you will need to create a “Custom question” using the filter builder.

Select one or more categories, click on "Actions" and select "Merge rows":

Result used in heading of a table:

For eample: