How to Unnest a Nested Banner in a Table

This article describes how to go from a table with a nested banner...

...to a table that unnests the banner into separate row spans:

Requirements

• A table which is crosstabbed with a banner that has multiple questions nested on top of one another.
• The question in the rows must not be a Pick One - Multi, Pick Any - Grid or Number - Grid.

Method

1. Select your table.
2. In the toolbar go to Automate > Browse Online Library > Modify Whole Table or Plot > Unnest Nested Banner on Table.
3. OPTIONAL: Untick Show significance testing message in footer if you don't wish to update the footer.
4. Press OK.

Please note the following:

• Significance testing results are not available once the table has been rearranged.
• Due to the nature of the changes, this resulting table will not behave like a normal Q table. For example, you cannot drag-and-drop to rearrange rows and the NET categories will appear when you export.
• Statistics to the right and below are not available on a table that uses this rule.
• Some statistics no longer make sense once the table has been rearranged and are not available. These statistics are:
  • % Column Share
  • % Row Share
  • % Share
  • % Total Responses
  • % Column Responses
  • % Row Responses
  • Index

Next

How to Use Rules in Q