Working with complex excel

[#1]

Hi

Most of the analysis i do with the excel and its little bit difficult to standardise them to system readable format.

I would like to know how can i show the attached excel in qlikview. Could anyone help me on this

thank you

[selvakumarsr]

Crosstable will help you to some extend for data cleaning but in your case is really a complex one..

[#3]

Budget and allocation is available for month, however actual and projection is available buyer wise and garment type wise ,

i wanted to see what is the budget ,allocation ,actual and projection for a given month then at least ,  i can identify the variance for the month