+ Reply to Thread
Results 1 to 3 of 3

an I create a PivotTable with two columns of data for the same Column header?

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    26

    an I create a PivotTable with two columns of data for the same Column header?

    Can I create a PivotTable with two columns of data for the same Column header?

    I have created a PivotTable in Excel 2003 with months for rows and cities for columns. I would like to have TWO columns of data for each city. The two data columns are: Average House Selling Price, and Number of Houses Sold. When I put both of these data fields into the PivotTable Wizard, they are listed below each other so that each Month occupies two rows, but each city occupies one column. I want the two data fields beside each other so that each month only occupies one row, but there are two data columns for each City. Is this possible, and if so how? Thanks for any suggestions.

  2. #2
    Forum Contributor ptm0412's Avatar
    Join Date
    04-16-2008
    Location
    Vietnam
    MS-Off Ver
    Office 2003 and 2007
    Posts
    129

    Re: an I create a PivotTable with two columns of data for the same Column header?

    In Excel 2003, right click at the cell "Data", then choose Order and then choose Move to Columns.
    Last edited by ptm0412; 12-24-2012 at 12:45 PM.
    Oldman Chatting: [email protected] Mailing: [email protected]

  3. #3
    Registered User
    Join Date
    04-13-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: an I create a PivotTable with two columns of data for the same Column header?

    Thank you so much !! It worked !

+ Reply to Thread

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