Help w/auto fill or copying

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

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



"melanemac" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> melanemac
> ------------------------------------------------------------------------
> melanemac's Profile:
http://www.excelforum.com/member.php...o&userid=17255
> View this thread: http://www.excelforum.com/showthread...hreadid=380980
>

Ron - that did it.

Thanks!