Hi - I am utilizing pivot tables to create 'data sets' that will be copy/pasted into another excel workbook. I am taking the larger set of data and breaking it down into subsets (our branches). I have months across the top and variables down the left side.
I need the data sets for each branch to have exactly the same number of columns (months) and rows (variables) every time, even if that branch did not have data for that month or variable. Is there a way to set a standard table that will not change as I chose the individual branches? (As I choose the indiv branches, the months or variables that don't have data disappear which will cause problems when pasting the data).
I've tried different ways of structuring the data (adding the branches along the top or down the side) to 'freeze' the table but there is too much data to do this.
Hopefully I'm explaining this well enough - does anyone have any suggestions? Thanks.
I need the data sets for each branch to have exactly the same number of columns (months) and rows (variables) every time, even if that branch did not have data for that month or variable. Is there a way to set a standard table that will not change as I chose the individual branches? (As I choose the indiv branches, the months or variables that don't have data disappear which will cause problems when pasting the data).
I've tried different ways of structuring the data (adding the branches along the top or down the side) to 'freeze' the table but there is too much data to do this.
Hopefully I'm explaining this well enough - does anyone have any suggestions? Thanks.
Last edited:
