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.