| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating Row Fields in a pivot table
Is it possible to get my row fields to repeat with every row instead of
having the row field appear once as a header for all related data? example: in a sales table by area: ROWS COLOMS Area1 11111 22222 31142 Area2 45354 54534 =================== Can I get "Area1" to repeat with all its sales values and so Area2 too? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeating Row Fields in a pivot table
Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "maghraby" wrote: Is it possible to get my row fields to repeat with every row instead of having the row field appear once as a header for all related data? example: in a sales table by area: ROWS COLOMS Area1 11111 22222 31142 Area2 45354 54534 =================== Can I get "Area1" to repeat with all its sales values and so Area2 too? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeating Row Fields in a pivot table
Thank Max for this.
But this solution is only applicable if i copy my pivot table data and paste in a new sheet which is not viewed as a pivot table. Is there a way to do this as an option for pivot tables? "Max" wrote: Try Debra Dalgleish's page for some nice ideas on filling in the blank cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "maghraby" wrote: Is it possible to get my row fields to repeat with every row instead of having the row field appear once as a header for all related data? example: in a sales table by area: ROWS COLOMS Area1 11111 22222 31142 Area2 45354 54534 =================== Can I get "Area1" to repeat with all its sales values and so Area2 too? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeating Row Fields in a pivot table
Nope.
maghraby wrote: Thank Max for this. But this solution is only applicable if i copy my pivot table data and paste in a new sheet which is not viewed as a pivot table. Is there a way to do this as an option for pivot tables? "Max" wrote: Try Debra Dalgleish's page for some nice ideas on filling in the blank cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "maghraby" wrote: Is it possible to get my row fields to repeat with every row instead of having the row field appear once as a header for all related data? example: in a sales table by area: ROWS COLOMS Area1 11111 22222 31142 Area2 45354 54534 =================== Can I get "Area1" to repeat with all its sales values and so Area2 too? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeating names in row fields of a pivot table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table - Repeating Lables | Excel Worksheet Functions | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Repeating data in a Pivot table | Excel Worksheet Functions | |||
| Pivot Table sum option - Only partial info and repeating | Excel Discussion (Misc queries) | |||
Linear Mode
