How to Show Heirarchical data in single column

See more:

SQL-Server

SQL-Server-2008

Hello Friends,

I have a requirement that to show hierarchical records into the single record.
like i have table table1 with data:

emp_id old_status new status 
1      A          B
1      B          C
1      C          D
2      A          B
2      B          C
2      C          D
2      D          E

I want to show records in following manner:

emp_id status1 status2 status3 status4 status5
1      A       B       C       D
2      A       B       C       D    E

Thanks in advance
Rohan Lokhande