Open topic with navigation

Merge Equal Cells

The Merge Equal Cells transformation merges adjacent cells that contain identical / equal values. It can be applied to merge equal cells in the entire table or in specific rows or columns. Both horizontally and vertically adjacent cells can be merged. The transformation also merges adjacent spanned cells that contain identical values.

If two equal cells appear from merging other cells, they are also merged. The transformation repeats the merging process until there are no more cells to merge.

Note: The cells must be adjacent to one another in the table before they can be merged. This means that additional transformations, such as Standard Sorting, may need to be applied to position the cells next to each other so they can be merged.

Prerequisites

The instructions in this topic assume that you have already added the Merge Equal Cells transformation to your table by following the instructions in the Add a Transformation to a Table or Table Type subsection of the Table Transformations topic here.

Example

Before

This is how the table appears before applying the Merge Equal Cells transformation:

After

This is how the table looks after.

Steps

1. After adding the transformation, the identical cells that are adjacent to one another will automatically merge.
2. If you want to limit the cells that are merged to specific rows or columns, click the ellipsis button () under Parameters to launch the Merge Equal Cells dialog.

3. Check Limit to row/column to apply the transformation to a specific row or column only, then click the ellipsis button () to launch the Select Row/Column dialog.

The options available in this dialog have already been explained in the Row/Column Text Formatting section of the Formatting Transformations topic (here); refer to that topic for more information.

4. Click OK when complete.

2019, Stibo Systems – Confidential