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