My Oracle Support Banner

How To Unmerge Cells After Exporting To Excel When The Cells Are Merged In Answers? (Doc ID 1930660.1)

Last updated on JANUARY 27, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Business Intelligence Answers Option - Version and later
Oracle Exalytics Software - Version and later
Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


Is there way you can un-merge cells (rows) when exporting to Excel in  You want to keep merge format on the dashboard, but unmerge only when exporting to Excel.

For example, the OBIEE report is  doing a group sort by year, brand and then a sum by individual office.   With this group sort, the year and brand value are not repeated in each row and only display when the brand or year changes as shown in the screen shot below:


When  exported to Excel, it retains the distinct group sort look of the OBIEE  report, as shown below, but the preferred Excel display is to repeat the group sort columns in every row so that every cell in every row has a value.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.