One of the Access tables in the application I am building will be populated via Excel. The data contained in the Excel spreadsheet itself comes off of a Cognos extraction that is in the form of a crosstab.
Unfortunately, the crosstab is of no help to me as I need a "flat" representation on Excel for my upload to work. How do I ensure that the Excel file from Cognos that is in the form of a crosstab is inverted to a flat form? This may sound confusing, so here is the example:
Apparently, the Cognos report can only give it this way, according to the guys who will be giving me the data from Cognos. I would need to "turn this around" to make the kind of flat spreadsheet I am looking for.