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
Bookmarks