hi!

in sheet1, i am having codes (numerical or text) in col A and values
in col B as under:


COL A COL B
abc 10
abc -10
1111 20
2222 30
1111 -40
ab123 50
ab123 60
2222 -10
abc 20


now what i want is in sheet2 codes in COL A and values in COL B ,
COL C, COLD ..etc in row wise as under:

COL A COL B COL C COL D
abc 10 -10 20
1111 20 -40
2222 30 -10
ab123 50 60

any help pl?

thks

-via135