Transpose column into rows

Hi Friends,


How to transpose the columns into rows

i want to convert the table which looks like this
ID Name HomePhone WorkPhone Email
1 test1 678364 643733 test1@xxxxxxxx
2 test2 678344 643553 test2@xxxxxxxx


to a table which should look like this
ID Name Device
1 test1 678364
1 test1 643733
1 test1 test1@xxxxxxxx
2 test2 678344
2 test2 643553
2 test2 test2@xxxxxxxx


Thanks in Advance
Arunkumar

.