Loading Two columns as header from Excel

[pavanthota]

Hi ,

Can any one please help me my requirement.

I have the Data like below in Excel in one sheet

Target_Date    Ordered_Date   Completion_Date

12/12/2012     05\12\2012        08\12\2012

ID      Name  Location

1      John     NAM

2    chris      APAC

while loading this exel sheet to qlikview i have to take first column and third column as headers .

I have to report the table like this below  on the main screen

ID NAME  Location Target_Date  Ordered_Date Completion_Date

[Jason_Michaelides]

It's hard to see from your description of the Excel layout what it really looks like. Can you post a sample of the excel data?