Help with crosstable

[Anonymous]

was able to do the cross table. But my column header date format is not coming proper. Attached is the excel i need Month data which is header, Attached is the excel sheet. can anyone help

[sunny_talwar]

Try this:

Table:

CrossTable (Date, Value)

LOAD [Employee Name],

     [41640],

     [41671],

     [41699],

     [41730],

     [41760]

FROM

tickets.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

NoConcatenate

LOAD [Employee Name],

  Date(Num#(Date)) as Date,

  Value

Resident Table;

DROP Table Table;

[Anonymous]

Let me try that rey Sunny. I got the solution but i want to check yours too.