Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
Send to Excel doesn't merge the cells
Article Number: 000003808 | Last Modified: 2019/01/17Description
We export Pivot table to Excel sheet and find cells are not merged in Excel Sheet.
Is there any workaround?
Pivot table Excel Sheet
Resolution
This is by design. Cell merge is not allowed in data exports since this would compromise data integrity.
Below is the workaround.
1. Right click Pivot table
2. Copy to clipboard
3. Choose Full table/Table data area
4. Paste in Excel
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.