You can use Table and Crosstab components which will export to Excel very well.
If you cannot use these components for some reason, you can use horizontal grid formatting on the Detail band so that it will export without blank columns or merged columns.