We are working on a bonus spreadsheet for all of our 10,000 employees. Pages
of data were sent to to me to manipulate the data. As you can see there is a
row between each employees data; however, when you look at George Jones, his
personal ID and name stops on row 1. Is there was away for each ZJ77130 row
carry the ID and name down to each row and have it stop on the last row where
the new name picks up?

EXAMPLE:
1302190 0413668 Axe, Tom Jones

ZJ77130 0155052 Jones, George
ZJ77130
ZJ77130
ZJ77130

1306005 0316997 Phillips, Shan
1306005
1306005

1306005 0144832 Cruise, Sheila
1306005