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

  • Thread starter Thread starter smaw
  • Start date Start date
S

smaw

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
 
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]
 
Back
Top