Uploading merged headers

[QS21]

 Hi,

I have an excel format like this from which I only need the data highlighted in orange.  Kindly help.

[avinashelite]

As per my knowledge Qilk can't read the color format and load the data from Excel .

Share the sample data set we will try to check any other workarounds 

[QS21]

Hi, sorry my bad. I doin't mean to pick data based in color. I am just letting yiu know which details I need from the above excel. When I transposed the table in Qlik, I am only getting "H1" under Jan and Feb but not H2 and total. How do I get those details as well?

[avinashelite]

Oh okay , could you please share the sample file and the code so that we could check what is the issue with code 

[QS21]

Hi Attached the sample data, sorry that I don't have proper code to share.