Home |
Search |
Today's Posts |
#1
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
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
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables show actual name rather then "Column Labels" | Excel Discussion (Misc queries) | |||
How do I remove old labels from refreshed pivot tables? | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Tables and Column Labels | Excel Discussion (Misc queries) | |||
excel graphs data labels in Pivot tables | Charts and Charting in Excel |