View Single Post
  #3   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by CherylK View Post
I have a two rows of labels but the second row of labels I want them in one
column not across as a column heading as I am using the column headings for
another purpose. We have two names for our salons the first is a source code
from an older system and the second is the real name I want to list both
together in the row labels but across from each other not below. Any
suggestions:

example:

BEATYB BEAUTY BEAT SALON
CASPER CASPER'S HAIR CARE

thanks to who can help
After arranging them in rows labels in excel 2007, for more visbility
1. Right click on pivot table
2. choose pivot table options
3. choose display
4. check in the option called "Classic pivot table Layout(enables dragging of fields"

All the best
__________________
Thanks
Bala