help on insert rows and fill down loop until end

[mark mcgrath]

Hello
I need help with the following
I have data from A1:J30
A1 has 3-7 address number
B1 has the street nam
C1 has the city and so on

I need to insert the number or rows for every unique address number in A1 then fill from B1:J1 and loop til end. My current 300 records should produce 9000 or so records. Can any one help me with this

Thank you in advance

Mark McGrath

 

[Tom Ogilvy]

fill B1 to J1 with what? Should the street name and city be overwritten.
What does "so on" mean.

What goes in the 3 - 7 rows - do they remain empty?

--
Regards,
Tom Ogilvy

Hello,
I need help with the following:
I have data from A1:J300
A1 has 3-7 address numbers
B1 has the street name
C1 has the city and so on.

I need to insert the number or rows for every unique address number in A1

then fill from B1:J1 and loop til end. My current 300 records should produce
9000 or so records. Can any one help me with this.