Moving an Excel pivot table to access

[Guest]

I have a huge (30MB) pivot table with lots of market data. However, I need
to pull this into Access in order to really crunch the data properly.

The data looks like this:

Region Vendor Product shipped units, etc.

Currently the pivot table shows "USA" for the region once, then the Vendor
name once, etc. so that when I pull it into Access, all I have is one row
with all of the data.

I would like to either output a pivot table where every single cell is
populated or create a macro that goes down a column, and if the cell is
empty, copies the value of the cell above; if the cell is populated, it skips
down to the next cell without doing anything.

I do not have access to the source information, only the pivot table.

 

[Guest]

What I do is recreate the pivot table using a formula such as...
If(len(A2)=0,A1,A2)
and copy that logic all the way down the rows and across the appropriate #
of columns. Then I Paste>Value it.
HTH,

 

[Guest]

What I do is recreate the pivot table using a formula such as...
If(len(A2)=0,A1,A2)
and copy that logic all the way down the rows and across the appropriate #
of columns. Then I Paste>Value it.
HTH,

 

[Debra Dalgleish]

You may be able to extract the data by double-clicking on the grand
total cell in the pivot table.

 

[Debra Dalgleish]

You may be able to extract the data by double-clicking on the grand
total cell in the pivot table.