Copy Data in excel 2003
 

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.

Copy Data in excel 2003
 

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

Copy Data in excel 2003
 

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.

Copy Data in excel 2003
 

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.