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.

Select your table.
In the toolbar go to Automate > Browse Online Library > Modify Whole Table or Plot > Unnest Nested Banner on Table.
OPTIONAL: Untick Show significance testing message in footer if you don't wish to update the footer.
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

Significance testing results are not available once the table has been rearranged.

Select the table(s)/chart(s) that you wish to apply the rule to.
Start typing the name of the Rule into the Search features and data box in the top right of the Q window.
Click on the Rule when it appears in the QScripts and Rules section of the search results.

Select a table or chart that has the rule and any table(s)/chart(s) that you wish to apply the rule to.
Click on the Rules tab (bottom-left of the table/chart).
Select the rule that you wish to apply.
Click on the Apply drop-down and choose your desired option.
Check New items to have it automatically applied to new items that you create. Use Edit > Project Options > Save as Template to create a new project template that automatically uses this rule.

Select the table(s)/chart(s) that you wish to remove the rule from.
Press the Rules tab (bottom-right corner).
Press Apply next to the rule you wish to remove and choose the appropriate option.

Click on the Rules tab (bottom-left of the table/chart).
Select the rule that you wish to modify.
Click Edit Rule and make the desired changes. Alternatively, you can use the JavaScript below to make your own rule (see Customizing Rules).