Usage of Excel table:different columns with same content
I've got a little issue with an excel-sheet, I created for the usage in QLIK. The sheet looks like this:
As it can be seen, I have several columns, that contain the same content: Projekt and Zeit.
In fact the table could look like this also:
As it is easier for me to design the excel sheet like seen above, I would really like to keep it like it is. Is it possible to integrate this form of sheet in QLIK, so that I could tell QLIK f.e. to create the field "Projekt" as a list of all seen six columns of Projekt and elsewhise with "Zeit"?