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 1
Fig 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