Howdy folks, I have a bit of an issue here. I am trying to import a datasource from an MS Access report. Essentially I have two grouping levels in the report. In the detail of the report, there are a few different fields that must appear on top of one-another in order to show the steps of a specific calculation. So my report would look like this:
The issue arises when I attempt to import this data into excel. Since calc1, calc2, and calc3 have their own headings in the datasource itself, excel imports them as such:
How do I go about making excel to order the different calc fields vertically instead of horizontally?