Dear Sir,

May I know if it is possible for me to realign data in Table 1 to Table 2 in
a single step by entering formulas in block A10: C25 ?

At present I do it in a few steps by transposing it first, and entering 3
seperate formulas at A10, B10 and C10 then copy downwards.


Table 1

A B C D E
Code 1 2 3 4
1 K125 200 250 390 410
2 P254 300 360 660 840
3 S141 400 380 910 520
4 T287 500 420 210 180



Table 2

10 K125 1 200
11 K125 2 250
12 K125 3 390
13 K125 4 410
14 P254 1 300
15 P254 2 360
16 P254 3 660
17 P254 4 840
18 S141 1 400
19 S141 2 380
20 S141 3 910
21 S141 4 520
22 T287 1 500
23 T287 2 420
24 T287 3 210
25 T287 4 180


Thanks

Low

--
A36B58K641