multiple values into separate columns by its unique id field

[ciarra41]

old table:
idnum values
5548 2s1dd
5548 35dd6
5548 4548p
5584 22de1

New table or sql:
idnum value1 value2 value3 value4
5548 2s1dd 35dd6 4548p 22de1

 

[Alan0568]

SELECT * FROM (SELECT idnum,value FROM old_table) x
PIVOT (min(value) FOR value IN ([1],[2],[3],[4])) y

just extend the 1,2,3,4 to cater for how many there could be.