Need help to load data using cross tables

[#1]

hi friends,

can anybody helpmeout in resolving this issue

Issue is

I have a sample data as shown in figure which has two headers in the same source sheet as shown below

now i want the result in qlikview as below.. I want the last record to be updated for the time being and also let me know what i need to do if i would like to list all the records from 1 to 6 with the same order,target and delivery date populated in their corresponding columns instead of only the last record which is my current requirement now as displayed below in the image.

I thouth that a cross table can be used to get the above result ,im not sure ,kindly helpme out in getting this resolved.

Kind Regards

Anand.

[Anonymous]

I am not sure that you need a cross table.  I would do this in two stages.  I would load the sheet starting with the headers on row 3 (and all the subsequent rows).   Then I would do another load of the sheet preceeded by "join" to apply the date fields to each row you previously loaded.