Help w/auto fill or copying

  • Thread starter Thread starter melanemac
  • Start date Start date
M

melanemac

I receive a downloaded report and can't change the format in which I
receive the report. Therefore, I have to try and get these 20,000+
lines in a format I can use easily.

This is the format of the data:
Column A Column B Column C, etc....
Name 1____1001_______X
_____________________X
_____________________S
_____________________Y
Name 2____1002_______X
Name 3____1003_______Y
_____________________Y

____________________________________
Each name can have multiple rows of data and there are about 15
columns. I need the information for each row and my first thought was
to try and do a pivot table with each column and then just copy/paste
values, but because the name/number isn't listed in every row, I just
get a lot of blank rows.

Does anyone know of any way to fill the blank rows below the Name with
the same value as above, without me having to go through all 20,000
lines of data? I have also been wracking my brain of a way to import
this into Access to do the same thing with no luck.

Thanks!
Melane
 
Try this (assuming the blank areas truly are blank):

Select Columns A and B of your report range, or whatever range you need
to replace blanks (example: A1:B20,000)

Then: Edit>Go to> [Special . . .]
Select Blanks then click [OK]

While those blank cells are still selected:
Type an equal sign then press the up arrow key one time
Hold down the [Cltrl] key and press [Enter].

Does that do what you want?

Ron
 
Back
Top