Excel Export Splitting columns up
I have a Report viewer in ASP.NET. I have a report displayed that works fine. The report viewer has the option to export the data to an Excel file or PDF file. When the user exports the file to Excel, Excel takes the lines of data and splits it up into 2 columns, as in the screen shot below. I have all of the columns lined up in the Report in Visual Studio. The columns are, however, in different matrices in Visual Studio. Anyone have any ideas on how to get the data into one column?
select cells E9:E30
right-click on the selection
select delete
select shift cells left
right-click on the selection
select delete
select shift cells left
ASKER
I understand how to do that, my question was more along the lines of is there anything I can do programatically to fix this issue? Or the alignment of the report elements in Visual Studio? I want to do this as there are users who are not as proficient in Excel as you or I.
Hello, I just found this question in my open questions. Do you want to continue with it?
ASKER
Yes, I would like to. I have not found a solution yet.
Can you please upload a sample if they are all in a same format? If the format changes then send at least two so that I can see the variation.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
I've requested that this question be deleted for the following reason:
No longer needed
No longer needed
You asked for a solution and I gave it. You should either accept it or, if it does not work as expected, comment on it so that it may be addressed.
#35869182 works with the layout shown in the screenshot after the question
ASKER
Excelscreenshot.jpg