Load Null Values

[hasmyt]

I have an excel table that looks like this

Col1            Col2          A        B        C       D

'abc'           'A'              3         15       -        4

'abd'           'B'             -         1           -       10

When I convert this into a crosstable, the null values don't show up. However I need the null values as well. How do I do that?

[lironbaram · Accepted solution]

you can try this approach 

nullasvalue Score,Value;
//Set NullValue = 'NULL';

DataTemp:
LOAD
ID,
Score,
Value
FROM [lib://Downloads/test.xlsx]
(ooxml, embedded labels, table is Sheet1);

CrossTable(Type,Value,1)
load *
Resident DataTemp;

drop table DataTemp;