Transpose from Columns to Rows

[prees959]

Hi,  I have the following xls table :

	1	2	3	4	5
aaa	*	-	-	-	-
bbb	*	12,995	6,445	4,885	3,235
ccc	-	7,970	6,385	3,460	145
ddd	*	-	3,045	2,250	2,310
eee	-	15,070	3,110	5,495	1,165
fff	-	540	55	345	45
ggg	-	955	95	730	20
hhh	-	160	-	280	55
iii	-	115	70	170	80
jjj	-	-	-	-	-
kkk	-	305	-	2,280	325
lll	-	-	-	30	-
mmm	-	-	-	-	-
nnnn	230	-	-	-	-

Is it possible to transpose this during the load so I can get :

CODE	ID	Value
aaa	1	21
bbb	1	*
ccc	1	-
ddd	1	22
eee	1	2
fff	1	-
ggg	1	12
hhh	1	-
iii	1	-
jjj	1	443
kkk	1	-
lll	1	23
mmm	1	32
nnnn	1	230
aaa	2	234
bbb	2	12,995
ccc	2	7,970
ddd	2	-
eee	2	15,070
fff	2	540
ggg	2	955
hhh	2	160
iii	2	115
jjj	2	-
kkk	2	305
lll	2	-
mmm	2	-
nnnn	2	-

etc

etc

Many thanks for any help

Phil

[sunny_talwar · Accepted solution]

Check here

The Crosstable Load 

[prees959]

Thanks ! Works perfectly