Get rid of sub-sections- all fields in columns across top of report

[gambils]

We have updated our software for a program we use at work and it exports data to Excel differently than the prior version. The prior version used to put all the information in columns (see partial copy and paste below) which is how I like it. Now it exports the file with sections that have colored box headers sub-sectioning the report on a few of the fields such as MD, Hospital, Department, etc.

I might be able to fix the report to export differently but, assuming I can't, is there a way in excel to get rid of these unwanted sections and to put the exported data all in columns?

Appointment Start Date Appointment End Date Patient Patient ID1 Patient ID2 Activity Diagnosis Code Diagnosis Description Activity Note Appointment Status Department MD or Staff <colgroup><col width="77"><col width="88"><col width="47" span="3"><col width="50"><col width="64"><col width="82"><col width="50"><col width="112"><col width="94"><col width="42"></colgroup><tbody> </tbody>

<tbody>
</tbody>