All categories to show in pivot tables for use as dataframe?
 

Regarding: pivot tables. I cannot find a way to show repeated values in a
column in order to use as a dataframe. For example if I have two variables on
the left (e.g. food group (carb, fat, etc.) AND product (bread, pasta,
butter, etc)), I cannot get the pivot table to repeated show the food group
for each product within that food group. I.e. 'carb' will be written once (on
the left of bread) but the remaining products of that group will be blank for
group. This is frustrating, because to use this as a dataframe for
statistical analysis, I need 'carb' to be repeated against each product.
Please help! Thanks

All categories to show in pivot tables for use as dataframe?
 

Not possible within the actual pivot itself,
but possible on a copy* of the pivot
*paste special as values

See Debra Dalgleish's page for ways to fill in the col blanks:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically
[Sub FillColBlanks() by Dave Peterson]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"smaw" wrote:
Regarding: pivot tables. I cannot find a way to show repeated values in a
column in order to use as a dataframe. For example if I have two variables on
the left (e.g. food group (carb, fat, etc.) AND product (bread, pasta,
butter, etc)), I cannot get the pivot table to repeated show the food group
for each product within that food group. I.e. 'carb' will be written once (on
the left of bread) but the remaining products of that group will be blank for
group. This is frustrating, because to use this as a dataframe for
statistical analysis, I need 'carb' to be repeated against each product.
Please help! Thanks