you are probably exporting data from the data manager window - this way you export the data of dataprovider(s), it means the most detailed data as you get it from database.
If you use BO 6.x then get your grouped data (data in the tables) into Excel via File → Save As → XLS format.