Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Let me try that rey Sunny. I got the solution but i want to check yours too.