How to get required output in sql

[amitsingh308]

I writing a query as follow

Select  'I87' [Location],PC.Company_Name [Company Name], Q.Department,PG.Group_Name [Group Name], 
PS.SGroup_Name [Sub Group Name], PB.Item_Code[Item Code],PB.Item_Name [Item Name], 
Sum(isnull(BD.Qty,0)) [Quantity],  Sum(isnull(BM.Net_Amount,0))[Bill Amount]   from I87.I87.Bill_Master BM    
inner join I87.I87.Bill_Detail BD on BM.BillNoWPrefix=BD.BillNoWPrefix  
inner join Packing_Belongs PB on PB.Item_Code=BD.Item_Code    
inner join Prop_Company PC on PC.Company_ID=PB.Company_ID and  PC.Company_ID='2'  
inner Join PROP_Groups PG on PG.Group_Id=PB.Group_ID  and PG.Group_Id='49'  
inner join Prop_SGroup PS on PS.SGroup_Id=PB.SGroup_ID and  PS.SGroup_Id='32' 
inner join (Select Distinct Department from Packing_Belongs) Q on Q.Department=PB.Department and  Q.Department='Bakery' 
where BM.Bill_Date between '9/5/2011' and '9/20/2011'  
group by PB.Item_Code,PB.Item_Name,PG.Group_Name,PS.SGroup_Name,Q.Department,PC.Company_Name

and its output is as follow..

Location , Company Name, Department, Group Name, Sub Group Name Item Code, Item Name, Quantity, Amount

But I required output as following format as shown in Image attached with this query..

can any one tell me how can I do so??
** Edit **

[Rabbit]

You can use a pivot to get the values of a column across the top, but it only allows the use of one aggregate. I suppose you could use two pivots and then join them.