Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
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   Report Post  
Posted to microsoft.public.excel.misc
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   Report Post  
Posted to microsoft.public.excel.misc
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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables show actual name rather then "Column Labels" SQL2005_rocks Excel Discussion (Misc queries) 6 April 3rd 23 04:31 PM
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 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 01:31 PM.

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

About Us

"It's about Microsoft Excel"