hi 

this will work 

NullAsValue *;

Set NullValue = 0;

DetailTemp:
LOAD Country,
State,
[Def Value],
[User Value]
FROM
[Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Detail:
CrossTable(DATATYPE, CONSTANT, 2)
load *
resident DetailTemp;

drop Table DetailTemp;

STORE Detail INTO [DETAIL.csv] ( txt, delimiter is ',');