View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Pivot Table Columns

Hi,

Just place both of them in the row field area. If you are using Excel 2007,
roght click, go to pivot table options, display and check the box for
Classic pivot table layout

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CherylK" wrote in message
...
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