Horizontal To Vertical Sql Server

Question

Select (F1.D32-F1.D20) As Profit_For_The_Period ,
F3.D2 as Current_Libilities,
F5.D20 As Capital_Acount,
M1.Name As Name,
F2.D20 AS Loan_Liabilities,
F4.d1 As Opening_Diff --F2.D68 As Loan,
from Folio1 As F1
inner Join Master1 As m1 on m1.Code like '101'
or m1.Code Like '102' or m1.Code Like '106'
or m1.Code Like '109' or m1.Code lIke '103'
inner Join Folio1 As F2 On (F2.MasterCode=F2.MasterCode)
inner Join Folio1 As F3 On (F3.MasterCode=F3.MasterCode)
inner Join Folio1 As F4 On (F4.MasterCode=F4.MasterCode)
inner Join Folio1 As F5 On (F5.MasterCode=F5.MasterCode)
Where F1.MasterCode=109
and F2.MasterCode =106
and F3.MasterCode=103
and F4.MasterCode=102
And F5.MasterCode=101

Below is my Output

 

1    12392     0     0     Capital Account      4000     -200

2    12392     0     0     Current Assets        4000      -200

3    12392     0     0     Current Liabilities   4000     -200

4    12392     0     0     Loans (Liability)     4000     -200

5    12392     0     0     Revenue Accounts  4000     -200

 

desire Output

 

1 Capital Account        12392

2 Current Assets           0

3 Current Liabilities     0

4 Loans (Liability)        4000

5 Revenue Accounts     -200