how to load spreadsheet with merged headers

[twills12]

Struggling with the proper way to code my load statement.  I have an excel file with merged headers that makes it difficult to tell the time periods.

Is there a way to associate the years correctly with each of the phase/quarters?

[vishsaggi]

What is your expected output?

[twills12]

Maybe something like this?

[vishsaggi]

How is your rawdata like? In your first excel sheet you sent us some pivoted data. In your second excel sheet you have all the data properly adjusted. So can you clarify like what is your original data looks like and what it should be converted to?

[twills12]

The first file is a subset of the source data.  That is how they have it for me to load.

The second file is what would be easiest to have in my application to build their charts upon.

So I guess the question is, can the load be coded to take the first file and have the resulting table look like the second file?

[vishsaggi]

Cross Load should do. You should check here?

The Crosstable Load

[vishsaggi]

Not a straight forward option you have to manipulate some transformations in it.

[twills12]

Yes the use of the merged headers for the years is making it a little difficult, otherwise it would be easy enough to do.