LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default pivot table questions

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table - New Data Allen Excel Discussion (Misc queries) 2 November 16th 05 03:15 AM
pivot table rmsterling Excel Discussion (Misc queries) 5 November 14th 05 04:40 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
Pivot Table - Multiple consolidation Range tengreen Excel Worksheet Functions 1 July 1st 05 07:18 PM
I am having trouble keeping numbers formatted in a Pivot Table Liana H Excel Discussion (Misc queries) 1 April 22nd 05 07:43 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"