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?
<tbody>
</tbody>
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?
<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>
Last edited: