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.

--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 clickPasteSpecialFormulas. will
fill in with the data you need..
--Once done you can select col A Copy PasteSpecialValues to turn
formulas to actual values

If this post helps click Yes
---------------
Jacob Skaria


"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.

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.

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.