Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |