Results 1 to 4 of 4

Pivot Table - Displaying Data Rows into Columns

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2011
    Location
    Palo Alto, CA
    MS-Off Ver
    Excel 2003
    Posts
    6

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1