+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Issue - Column will not copy down due to common value

  1. #1
    Registered User
    Join Date
    04-05-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Pivot Table Issue - Column will not copy down due to common value

    I am trying to build a template and the data from my Pivot table is being used on another sheet in the workbook.

    I work in production scheduling so we have a download with the start date. Problem is that multiple orders start on the same date and the first value must be the work center


    So for example, order Z and order X start on the same date and run on the same work center. In the pivot table, it only lists the date once in row 1. I would like it to list the date and work center in each row in which there is a value.

    Current:

    Column A Column B Column C

    Work Center Start Date Sales Order
    Row 1 85 4/15 Z
    Row 2 X


    Ideal:

    Column A Column B Column C

    Work Center Start Date Sales Order
    Row 1 85 4/15 Z
    Row 2 85 4/15 X
    Last edited by tl1735; 04-15-2010 at 04:06 PM. Reason: Pivot TABLE, not chart

  2. #2
    Registered User
    Join Date
    04-05-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Pivot Table Issue - Column will not copy down due to common value

    Attached is an example of what I have currently and what I'd like in the future.
    Attached Files Attached Files

+ 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