same description in excel field

[anat]

hi ,

how to load the attached excel file data.

what i am facing the problem is ,

after loading the data if i select Total1 and a  data is coming for jan 14,but what i want is separate records like

total1 and a value should be 1

total2 and a value should be 13

[Gysbert_Wassenaar]

Try this:

LOAD Desc,

  If(WildMatch(Desc,'Total*'),Desc,peek(Total)) as Total,

     jan,

     feb,

     mar,

     apr

FROM

     [test123,xlsx]

     (ooxml, embedded labels, table is Sheet1)

     ;