You can't have it repeat and still keep it a pivottable.

You can copy|paste special values (in the same place or on a new worksheet) and
now it's just data--and you can do whatever you want to it--including filling in
those gaps.

Debra Dalgleish shares some techniques for filling those cells:
http://www.contextures.com/xlDataEntry02.html

joeinnc wrote:

When setting up a pivot table and your first column is a unique indentifier,
how do yuo have that repeat for each row when you pivoted data for columns to
rows.

Example

Area Week 1 Week 2 Week 3 Week 4
1 5 6 7 8

When you pivot this it shows the data like this;

Area Data Total
1 Sum of Week 1 5
Sum of Week 2 6
Sum of Week 3 7
Sum of Week 4 8

I need the area identifer to show on each row of data not just the first row.

--

Dave Peterson