how to convert row data into column dynamically in sql-server with rank function

I want to convert row data into columns dynamically from two tables.

Plz help me. i have data in following format from two tables

Reg no      Title              Marks Obt     Max Marks
10900231    Asgn 1             10.00         15
10900231    Asgn 2             10.00         15
10900231    Asgn 3             5.00          15
10900231    P4                 75.00         100
10900231    P5                 65.00         100
10900231    P6                 80.00         100
10900231    P7                 80.00         100

10900232    Asgn 1             12.00         15
10900232    Asgn 2             13.00         15
10900232    Asgn 3             5.00          15
10900232    P4                 75.00         100
10900232    P5                 65.00         100
10900232    P6                 80.00         100
10900232    P7                 80.00         100

But i want to result in follwing format to dynamically make columns:

Reg NO         Asgn 1       Asgn 2     Asgn 3 P4   P5   P6   P7    
10900231       10           10         5      75   65   80  80    
10900232       12           13         5      75   65   80  80