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?