I have some data which is row wise in table.I want those data in one column in sql server

i have a table like this

S.no No of hours Dayorder

1 5 1 2 6 2 3 8 3 4 7 4

---

i want the data to be displayed like this

Sno Day1 Day2 Day3 Day4

1 5 6 8 7