Crosstable doesn't work

[Anonymous]

Hi guys,

     I have an exel file like this:

A	B	C	D	E	F	G	H	I	J	K	L
48	843	3156	15	481	548	484	218	15	128	412	451

and I want this:

Type	Value
A	48
B	843
C	3156
D	15
E	481
F	548
G	484
H	218
I	15
J	128
K	412
L	451

So I'm using Crosstable to do this:

Crosstable (Type,Value, 0)

Load A,

     B,

     C,

     D,

     E,

     F,

     G,

     H,

     I,

     J,

     K,

     L

From ...

but it doens't work, and the result is a table equal to the source.

I don't understand why.

[YoussefBelloum · Accepted solution]

Hi,

yesterday I was stuck on doing a Crosstable without a qualifier column (like what you have here).

try to take your file and insert another column before the column A, insert any value on it.

when doing the crosstable on the Wizard, choose the new column as the qualifier column.

at the end of the script, you can drop this field.

drop field field_name from table_name;

[Anonymous]

Ok, this solution works, thanks

[YoussefBelloum]

You're welcome !

Good luck