Remove Grouping

Source Data

This function removes any previous grouping that has been applied to rows or columns by previous grouping functions.

Key Steps

To remove grouping from an existing table, follow the steps below.

Step #

Step Detail


Select the column or row that was previously grouped and which now you want ungrouped– those rows will be showing Excel grouping controls.


Click on the “Remove Grouping” button in the TreeWiz Ribbon Menu


Confirm that the source range is correct in the parameter form


Click on “OK’ to perform the function or “Cancel” to exit


The function will complete, and a dialog box will inform you on completion


Click on “Ok” button to dismiss the dialog box



Table 15: Group by Column Offset Key Steps


The following dialog / form appears, containing the parameters required to create a metadata schema from your source data.

Figure 32 – Group by Column Offset Parameters Form

The table below describes the parameters in more detail.

Table 16: Group by Column Offset Parameters Description Table

Property Name


Data Type

Source Range

Source Range Address

The source range for this function will be detected as the current active selection when the function is invoked.

The address is shown to the right of the Refresh button.

This source range can be changed after function invocation.



Click on the “Refresh” button to update the source selection.