Shane,

Thanks, can't attach the worksheet but will send it to you in a seperate
e-mail.

"ShaneDevenshire" wrote:

Hi,

Don't give up quit so quickly. You can infact do what you want if I
understand correctly.

Send me a sample file and I will send it back showning how this can be done.

--
Thanks,
Shane Devenshire


"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.