I'm stuck with a problem loading an excel file to qv, . I've attached a sample file that shows the structure of the original file as qv file wizard interprets it and the desired outcome.
Row 1 is a header row and I need to use field 'dept a', 'dept b' and so on as field values and skip the others. Column B is a date field in num format. Column A is just weekday as a text and refers to last years figures (those do not have reference to actual date data).
I guess a crosstable would do the trick, but I can't figure out the correct script. Any help would be appreciated.
