You can use the crosstable function to load the data and create another table for the categories. You may have to change the headers in the excel file so that all the headers are on the same row, i.e. moving Plant, Year and Month a row down instead of using merged cells.
load Plant, Year, Month, Col1,Col2,Col3,Col4,Col5,Col6
Load * inline [
thanks for your reply. Notice that I don't use the Excel file within QlikView. I'm using a database table but without the Category headers.
I only need these Category names for grouping.
Check out the attached sample.
Grouping.qvw 159.5 K