Query to make group of records
===

I am using SQL Server 2008 R2. I have a table having data like below : 

                     TableA
    ======================================
    Name      colB       colM        colP 
    ======================================
    T045      B          Null        Null
    T045      Null       M           Null
    T045      Null       Null        P
    T046      Null       M           Null
    T046      B          Null        Null
    T047      Null       Null        P
    T047      Null       M           Null
    T048      B          Null        Null


I want the query to have result like below : 

        ======================================
        Name      colB       colM        colP 
        ======================================
        T045      B          M           P
        T046      B          M           Null
        T047      Null       M           P
        T048      B          Null        Null

Can any one have idea? 

Thanks 
