Help w/auto fill or copying

[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

 

[Anne Troy]

Select the first cell below Name1. Select all cells below it until you get
to the last row of data. Hit Edit-->Go to-->Special. Choose Blanks. Ok.
Type =XXX (where XXX is the cell reference that Name1 is in.) Hit
Ctrl+Enter.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Ron Coderre]

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

 

[melanemac]

Ron - that did it.

Thanks