Select and merge rows?

Hello! I have a doubt about a query that I tried to do, but I cant...... This is the scenario: I have a table, with this rows: order    ID    value    ---------------------- 1    1000    3 2    1000    5 3    1000    6 1    1001    1 2    1001    2 1    1002    4 2    1002    4 I need to get this table, divided by ID, like this: id    value1    value2    value3 -------------------------------- 1000    3    5    6 1001    1    2 1002    1    2 How I can do this? I tried with cursors and view, but i can't.... Any help is welcome! Thanks in advance! Regards,