Convert Column value into Number of rows

Question

Guys in Sql Server How to make Last Column Thats is Speed Column as a Row For Perticular Rdr_no column.

 Thank you in Advance

 

RDR_No    Cvt_no    Sns_no    H_no    Speed

-------      --------      -------      ----------   ------

1169    B3_091    B3_040       96    025

1169    B3_091    B3_040       96    064

1169    B3_091    B3_040       96    096

1169    B3_091    B3_040       96    119

1146    B3_114    B3_024       54    026

1146    B3_114    B3_024       54    064

1146    B3_114    B3_024       54    095

1146    B3_114    B3_024       54    119

1161    B3_149    B3_053       17    025

1161    B3_149    B3_053       17    064

1161    B3_149    B3_053       17    096

1161    B3_149    B3_053       17    119

1167    B3_113    B3_122       103    026

1167    B3_113    B3_122       103    063

1167    B3_113    B3_122       103    095

1167    B3_113    B3_122       103    121