PivotTable Question
Posted by Brian on September 28, 2001 7:36 AM
I have a pivot table but would like to import this into access to do some data analysis. The problem is that pivot table looks great for people but is a nightmare for access since it has blank lines. My question is there a way to have excel put back in the missing info? Example
Cust 1 Product 1 Volume
Product 2 Vol
Cust 2 Product 1 Volume
Product 2 Vol
But need it to be
Cust 1 Product 1 Volume
Cust 1 Product 2 Vol
Cust 2 Product 1 Volume
Cust 2 Product 2 Vol
Thanks for the help,
Brian