Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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);
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);