Splitting rows

You can split a row if one of its columns has two subcolumns.

Procedure

To split a row:

  1. Right-click a cell in the row you want to split. The chosen cell must be in a condition column that has subcolumns.
    Cell in the row you want to split
  2. Click Split button Split.

    When a row made up of grouped cells is split, the values of the column are split across two rows. The other values in the row are duplicated in the new row:

    Row made up of grouped cells is shown split
  3. To specify the empty values, double-click an empty cell and enter or select the required value, as appropriate.