Merge or unmerge query table output cells
To make tables easier to read, you can merge cells that have identical values.
- Define a query or start a private one.
- Activate the
Spreadsheet bar and select the Template sheet of the required table. - 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.
- Enable the Merge results check box if you want to merge cells in the Result sheet.

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

- Specify the relevant settings and click OK.
- Activate the Start tab bar and click
Evaluate table.
You have changed the merge settings for the item cell.
See also
How are query output tables sorted?