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
