How to remove unwanted string in sql server : I am making product inventory and showing data using below statement

    SELECT _PRODNAME      AS [Manufacture Product], 
           _BASEPRODNAME  AS [Sub Product], 
           _PRDDEFQTY     AS [Required Qty / Unit], 
           _PURQTY        AS [Purchase Qty], 
           _PURRETQTY     AS [Return Qty], 
           _ISSUEQTY      AS [Issue Qty], 
           _DAMAGEQTY     AS [Damage Qty], 
           _BALQTY        AS [Balance Qty], 
           _MINESTIMATE   AS [Estimate Qty], 
           _SALEQTY       AS [Sale Qty], 
           _MANUDAMAGEQTY AS Damage, 
           _AVAILQTY      AS [Avail Qty] 
    FROM   dbo.VIEW_MANUFACTURING 

this giving me result as 


    manu			2 GOOD				34.00		502.00		0.00		0.00		0.00		502.00		14.705882	0.00	0.00	14.71
    manu			CHOCO ALMOND 1\2 kg	34.00		500.00		0.00		0.00		0.00		500.00		14.705882	0.00	0.00	14.71
    Vanila Cake		Butter Cream		10.00		600.00		0.00		72.00		0.00		528.00		52.800000	0.00	0.00	52.80
    Vanila Cake		Eggs				2.00		1000.00		0.00		37.00		0.00		963.00		52.800000	0.00	0.00	52.80
    Vanila Cake		Flour				5.00		500.00		0.00		0.00		0.00		500.00		52.800000	0.00	0.00	52.80

but my expected result is 

        manu																						14.705882	0.00	0.00	14.71
    			2 GOOD				34.00		502.00		0.00		0.00		0.00		502.00	
    			CHOCO ALMOND 1\2 kg	34.00		500.00		0.00		0.00		0.00		500.00	
    Vanila Cake																					52.800000	0.00	0.00	52.80
    			Butter Cream		10.00		600.00		0.00		72.00		0.00		528.00		
    			Eggs				2.00		1000.00		0.00		37.00		0.00		963.00	
    			Flour				5.00		500.00		0.00		0.00		0.00		500.00	

in my sample data Vanila Cake is main product and Butter Cream, Eggs, Flour are sub product, Columns 3,4,5,6,7,8 are for sub product data and Columns 9,10,11,12 are for main product.

My question is how to show this data seprately, I dont have any idea to this.