Hello,

When using a pivot table the data looks like the table below. Besides using
copying then pasting and then using the edit, go to, is there another way to
fill in the blanks below the reps name?

Thanks for you help.


Event Type ACD INCOMING

Count of Queue Number
Extn Name Queue Number Total
Rep 1 Q10550 4
Q10552 9
Q10553 11
Q10557 1
Q10558 1
Q10559 1
Rep 2 Q10550 2
Q10551 7
Q10552 2
Q10553 5
Q10555 2
Q10558 2
Rep 3 Q10554 7
Q10555 12
Rep 4 Q10550 1
Q10551 1
Q10553 1
Q10555 1
Q10559 5

The short answer is: No

But, what you're saying you want may not be what you need.
What are you trying to do?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JR" wrote:

Hello,

When using a pivot table the data looks like the table below. Besides using
copying then pasting and then using the edit, go to, is there another way to
fill in the blanks below the reps name?

Thanks for you help.


Event Type ACD INCOMING

Count of Queue Number
Extn Name Queue Number Total
Rep 1 Q10550 4
Q10552 9
Q10553 11
Q10557 1
Q10558 1
Q10559 1
Rep 2 Q10550 2
Q10551 7
Q10552 2
Q10553 5
Q10555 2
Q10558 2
Rep 3 Q10554 7
Q10555 12
Rep 4 Q10550 1
Q10551 1
Q10553 1
Q10555 1
Q10559 5

Thanks for your response.

I need to get the data by rep into a different report. I need to be able to
use a sum product so the individual queues can be added. If the blanks were
filled in the task (to me anyway) would be easier.

"Ron Coderre" wrote:

The short answer is: No

But, what you're saying you want may not be what you need.
What are you trying to do?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JR" wrote:

Hello,

When using a pivot table the data looks like the table below. Besides using
copying then pasting and then using the edit, go to, is there another way to
fill in the blanks below the reps name?

Thanks for you help.


Event Type ACD INCOMING

Count of Queue Number
Extn Name Queue Number Total
Rep 1 Q10550 4
Q10552 9
Q10553 11
Q10557 1
Q10558 1
Q10559 1
Rep 2 Q10550 2
Q10551 7
Q10552 2
Q10553 5
Q10555 2
Q10558 2
Rep 3 Q10554 7
Q10555 12
Rep 4 Q10550 1
Q10551 1
Q10553 1
Q10555 1
Q10559 5