Merge or unmerge query table output cells

To make tables easier to read, you can merge cells that have identical values.

  1. Define a query or start a private one.

  2. Activate the Spreadsheet Spreadsheet bar and select the Template sheet of the required table.

  3. Double-click the query item which cells in the Result sheet you want to be merged or unmerged. The Edit item cell properties dialog opens.

  4. Enable the Merge results check box if you want to merge cells in the Result sheet.

    Merged cells

    If you want that each related cell in the Result sheet shows the related value, disable the check box.

    Unmerged cells

  5. Specify the relevant settings and click OK.

  6. Activate the Start tab bar and click Evaluate table Evaluate table.

You have changed the merge settings for the item cell.

See also

How are query output tables sorted?