Help with crosstable

[maxsugak]

Dear fellows,

need help to cross table with multiple values, tried a lot but always get it wrong.

Please check Excel attached.

View or Sense, does not matter.

Thanks!

[rogerpegler · Accepted solution]

In Excel, copy and paste with the transpose option, so that you now have something like the attached.

The load code would then be:

CrossTable(FieldName, Data, 2)
LOAD F1 as Week,
CTV,
[5tgb4],
[3f4efn],
v34ge,
[56j56j],
m5j6hj,
[5yj56h],
h54y3
FROM
Temp2.xlsx
(ooxml, embedded labels, table is Sheet1);