+ Reply to Thread
Results 1 to 1 of 1

PivotTable Help - Multiple columns with same title

  1. #1
    Registered User
    Join Date
    07-15-2011
    Location
    HOUSTON, TX
    MS-Off Ver
    Excel 2003
    Posts
    6

    PivotTable Help - Multiple columns with same title

    Hello,

    I need help with PivotTable please. I have a sheet that has multiple columns with same names. i.e.:
    Usages - Month 1 - Invoice - Month 1 - Discounts - Month 1

    When I run the Pivot Table Report, under "Choose Fields to Add to the Report' it combines the columns with the headings 'Month 1'; is there any way to show me these fields as it appears on the data sheet and in the same sequence?

    I would not be able to change the headings coz' sometimes I get over 50 sheets at a time.

    All the help will be greatly appreciated.

    Regards!

    Shaheed Faiz
    Last edited by shaheedfaiz; 07-22-2011 at 12:20 PM.

+ 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