Copy Data in excel 2003

[JS1]

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.

 

[Jacob Skaria]

--Select a unused cell say E2
--Enter the formula in cell E2 which references the top cell (=E1)
--Copy the cell
--Keeping the copy select the data range in ColA (say A1:A12).
--Press F5. From Goto window select blanks
--This will select all blanks.. Now Right click>PasteSpecial>Formulas. will
fill in with the data you need..
--Once done you can select col A > Copy >PasteSpecial>Values to turn
formulas to actual values

If this post helps click Yes

 

[Pete_UK]

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

 

[JS1]

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

Rgds.,
John.