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.