A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Pivot tables 2 row labels



 
 
Thread Tools Display Modes
  #1  
Old February 23rd 10, 06:02 PM posted to microsoft.public.excel.misc
sdav
external usenet poster
 
Posts: 6
Default Pivot tables 2 row labels

I am trying to create a pivot table and want to have sales rep names and
company as the rows. Is there a way to have the sales rep name repeat
everytime with the company instead of how it looks below? I am going to have
to use the output of the sheet to do a vlookup on another sheet and in this
format I can't make it work. Thanks!

Row Labels
Jane Doe
Company 1
John Doe
Company 2
Company 1
Company 3
Company 5

Ads
  #2  
Old February 23rd 10, 07:14 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Pivot tables 2 row labels

Nope--not if you want to keep it a pivottable.

But you could convert to values (or copy|paste values in a different location),
then fill the blank cells with the value of the cell above it.

Debra Dalgleish's site has some tips:
http://contextures.com/xlDataEntry02.html

sdav wrote:
>
> I am trying to create a pivot table and want to have sales rep names and
> company as the rows. Is there a way to have the sales rep name repeat
> everytime with the company instead of how it looks below? I am going to have
> to use the output of the sheet to do a vlookup on another sheet and in this
> format I can't make it work. Thanks!
>
> Row Labels
> Jane Doe
> Company 1
> John Doe
> Company 2
> Company 1
> Company 3
> Company 5


--

Dave Peterson
  #3  
Old February 23rd 10, 10:27 PM posted to microsoft.public.excel.misc
sdav
external usenet poster
 
Posts: 6
Default Pivot tables 2 row labels

I don't want to keep it as a pivot table. It is a large spreadsheet so I was
trying to move everything manually.

The site you shared with the copying is great. I will use that info once I
get the data into 2 separate columns.

"Dave Peterson" wrote:

> Nope--not if you want to keep it a pivottable.
>
> But you could convert to values (or copy|paste values in a different location),
> then fill the blank cells with the value of the cell above it.
>
> Debra Dalgleish's site has some tips:
> http://contextures.com/xlDataEntry02.html
>
> sdav wrote:
> >
> > I am trying to create a pivot table and want to have sales rep names and
> > company as the rows. Is there a way to have the sales rep name repeat
> > everytime with the company instead of how it looks below? I am going to have
> > to use the output of the sheet to do a vlookup on another sheet and in this
> > format I can't make it work. Thanks!
> >
> > Row Labels
> > Jane Doe
> > Company 1
> > John Doe
> > Company 2
> > Company 1
> > Company 3
> > Company 5

>
> --
>
> Dave Peterson
> .
>

  #4  
Old February 25th 10, 07:28 PM posted to microsoft.public.excel.misc
sdav
external usenet poster
 
Posts: 6
Default Pivot tables 2 row labels

I can't find the video on the site you shared anymore. I was going to follow
the written instructions, but don't know where to find edit.

"sdav" wrote:

> I don't want to keep it as a pivot table. It is a large spreadsheet so I was
> trying to move everything manually.
>
> The site you shared with the copying is great. I will use that info once I
> get the data into 2 separate columns.
>
> "Dave Peterson" wrote:
>
> > Nope--not if you want to keep it a pivottable.
> >
> > But you could convert to values (or copy|paste values in a different location),
> > then fill the blank cells with the value of the cell above it.
> >
> > Debra Dalgleish's site has some tips:
> > http://contextures.com/xlDataEntry02.html
> >
> > sdav wrote:
> > >
> > > I am trying to create a pivot table and want to have sales rep names and
> > > company as the rows. Is there a way to have the sales rep name repeat
> > > everytime with the company instead of how it looks below? I am going to have
> > > to use the output of the sheet to do a vlookup on another sheet and in this
> > > format I can't make it work. Thanks!
> > >
> > > Row Labels
> > > Jane Doe
> > > Company 1
> > > John Doe
> > > Company 2
> > > Company 1
> > > Company 3
> > > Company 5

> >
> > --
> >
> > Dave Peterson
> > .
> >

  #5  
Old February 25th 10, 07:38 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Pivot tables 2 row labels

Debra Dalgleish explains how:
http://contextures.com/xlDataEntry02.html
and a video
http://www.contextures.com/xlVideos01.html#FillBlanks

The Edit is an option on the worksheet menubar in xl2003 and earlier.

If you're using xl2007 (or any version of excel!), you can hit: F5 or ctrl-g
to get to that dialog.

sdav wrote:
>
> I can't find the video on the site you shared anymore. I was going to follow
> the written instructions, but don't know where to find edit.
>
> "sdav" wrote:
>
> > I don't want to keep it as a pivot table. It is a large spreadsheet so I was
> > trying to move everything manually.
> >
> > The site you shared with the copying is great. I will use that info once I
> > get the data into 2 separate columns.
> >
> > "Dave Peterson" wrote:
> >
> > > Nope--not if you want to keep it a pivottable.
> > >
> > > But you could convert to values (or copy|paste values in a different location),
> > > then fill the blank cells with the value of the cell above it.
> > >
> > > Debra Dalgleish's site has some tips:
> > > http://contextures.com/xlDataEntry02.html
> > >
> > > sdav wrote:
> > > >
> > > > I am trying to create a pivot table and want to have sales rep names and
> > > > company as the rows. Is there a way to have the sales rep name repeat
> > > > everytime with the company instead of how it looks below? I am going to have
> > > > to use the output of the sheet to do a vlookup on another sheet and in this
> > > > format I can't make it work. Thanks!
> > > >
> > > > Row Labels
> > > > Jane Doe
> > > > Company 1
> > > > John Doe
> > > > Company 2
> > > > Company 1
> > > > Company 3
> > > > Company 5
> > >
> > > --
> > >
> > > Dave Peterson
> > > .
> > >


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove old labels from refreshed pivot tables? PRTex Excel Discussion (Misc queries) 3 September 16th 08 10:46 PM
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 09:05 PM
Pivot Tables show actual name rather then "Column Labels" SQL2005_rocks Excel Discussion (Misc queries) 5 February 13th 07 06:15 PM
Pivot Tables and Column Labels Mark McDonough Excel Discussion (Misc queries) 2 June 8th 06 03:05 PM
excel graphs data labels in Pivot tables Rosa Campos Charts and Charting in Excel 0 May 9th 06 07:55 PM


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


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