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