Pivot Table - Displaying Data Rows into Columns

Hello, I have a Pivot table that displays the totals of a two rows for each specific item in a column of item names. Currently, I've figured out how to get the data I want to display however it displays Row format. I want all the totals to be in their own column. See inventory_Purchase_ebay worksheet for the original pivot table and an example of how I want it displayed. Also I added some fields in the Pivot Table Field List dialog box. How do I delete them from there because as I experiment this list might get too long. thanks.

PS. I am using excel 2003

click on the pivot table, click on Format --> AutoFormat and choose the first design ("Report 1") and click ok

THanks that worked perfectly. Now for the same worksheet I need to create a average cost column. How would I go about doing this?

Can you just add Total in again and instead of "sum" make it "average" ? ....right click, select value field settings and set to average