Send to Excel doesn't merge the cells

[Yoichi_Hirotake]

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