MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Mark W. on September 28, 2001 8:16 AM

After you've performed a Copy/Paste Special Values
to create a list from your PivotTable...

Select the rows in the 'Cust' column, choose
the Edit | Go To... | Special... Blanks menu
command, enter an equal sign (=), click on the
cell immediately above the active cell selection,
press Control+Enter. Select the 'Cust' column
once more and perform Copy/Paste Special Values.

Posted by Brian on September 28, 2001 8:25 AM

WHOOHOO!!!

Thank you so much Mark...you have saved me much pain!!!!


Thanks,
Brian