SSRS Report with sub report column accessibility

Question

Hi ,

 

I have ssrs report with subreport when export this report to excel . In this excel single column of data accessing  2 or 3 merged columns in excel.

 

But, in report without subreport its working fine 

 

for e.g.

 

Name	DOB	Age
XXX	12/2/1995	23
Department

Department	count	total	status
CSE	21	34	active

   when export this report to excel 

 

single column accumulate  1 column pluse one more empty column why?