Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Pivot formatting
Hello. I would welcome someone's help on the following. I have a Pivot table
which looks like the following: Region SalesPerson Sales East Dave $100 Pete $200 Mike $240 I want the table to not leave the blanks on the left hand side. I want it to look like the following: Region SalesPerson Sales East Dave $100 East Pete $200 East Mike $240 I am then using this data to create another table. The blanks revent me from doing so. Does anyone know how to prevent the Pivot table from doing this? Thank you very much in advance. -- DM |
#2
|
|||
|
|||
You can't do that and still keep it as a pivottable.
But you can copy the sheet (if you need to keep the pivottable) and then change that copy to values. Now, since the data is no longer a pivottable, you can do whatever you want. I used a technique that Debra Dalgleish has at: http://www.contextures.com/xlDataEntry02.html#Fill (I use the manual method--I find it quicker than the macro!) Dave wrote: Hello. I would welcome someone's help on the following. I have a Pivot table which looks like the following: Region SalesPerson Sales East Dave $100 Pete $200 Mike $240 I want the table to not leave the blanks on the left hand side. I want it to look like the following: Region SalesPerson Sales East Dave $100 East Pete $200 East Mike $240 I am then using this data to create another table. The blanks revent me from doing so. Does anyone know how to prevent the Pivot table from doing this? Thank you very much in advance. -- DM -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Formatting of Pivot table | Excel Discussion (Misc queries) | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Pivot Tables lose some formatting when Updated | Excel Discussion (Misc queries) |