Merge cells

Manni_SM — Mon, 08 Jun 2026 09:57:30 GMT

i want to merge the cells if cell values is matching like below in excel and pixel perfect NP

field 1 | Field2 | Feild3

1,2,3

1,4,5

1,6,7

now my result should be in excel template

2,3

1 4,5

6,7

Re: Merge cells

Lech_Miszkiewicz — Tue, 09 Jun 2026 01:36:26 GMT

You may want to give us use case to better understand as to:

why you need to do this in XLSX and Pixel Perfect template
- the ways to do that in both tables are very different and depend on the use case
For excel - Can't you use native pivot table which will do this grouping for you?
- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-native-tables.htm
For excel - you may as well use excel conditional formatting (excel based function to colour code cell values and borders in straight table to make it look like they are merged although they would not be
For excel - you may as well use levels to mimic similar layout
For pixel perfect - there is no native option - it is just a matter of creating data in data source (qlik app table) which then you can use in conditional formatting of the table (this is time consuming task) to create grouping lookalike view by managing borders display and font colour display. Below link gives you idea how to conditional format things in pixel perfect. The same applies to borders
- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/PixelPerfect/pixelperfect-highly-formatted-table.htm#anchor-2

cheers