Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Send to Excel doesn't merge the cells

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Yoichi_Hirotake
Former Employee
Former Employee

Send to Excel doesn't merge the cells

Last Update:

Oct 12, 2020 7:43:54 AM

Updated By:

Sonja_Bauernfeind

Created date:

Oct 10, 2013 2:03:48 AM

We export a Pivot table (Fig 1) to an Excel sheet (Fig 2) and find cells are not merged in the Excel Sheet. 

Is there any workaround?

Fig 1Fig 1

Fig 2Fig 2

Resolution

 

This is by design. Cell merge is not allowed in data exports since this would compromise data integrity. 
Below is the workaround.

  • Right-click Pivot table 
  • Copy to clipboard
  • Choose Full table/Table data area
  •  Paste in Excel
Labels (1)
Contributors
Version history
Last update:
‎2020-10-12 07:43 AM
Updated by: