|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2010, 05:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
February 23rd, 2010, 06:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
February 23rd, 2010, 09:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
February 25th, 2010, 06:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
February 25th, 2010, 06:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
