Thanks to you both, for your quick & expert advice. Worked a treat & saved me
lots of manual work.

Rgds.,
John.

"Pete_UK" wrote:

Highlight your data area with the active cell as A1, then press F5
(GoTo), and click on Special, then click Blanks - A2 will now be the
active cell. Begin to enter a formula by typing =, then click on the
cell above (A1), then do CTRL-Enter and the formula will be propagated
to all the blank cells. You could then fix the values.

Hope this helps.

Pete

On Jul 20, 11:26 am, JS1 wrote:
Hi Forum,

In Excel 2003, I have a list of 1300 headers for 13000 records. My headers
are like below (Dogs, Cats, Balls...) and are associated to a varied amount
of records.

I want to replicate the headers to all associaed records (like Dogs A1-A3,
Cats to A4-A8, Balls to A9-A12, or into another column).

Dogs Spaniel
Poodle
Hound
Cats Black
Brown
Dark
Bright
White
Balls Black
Red
Blue
Green

Hope I've made what I am after, clear.
Thanks for your help.

John.