How do I repeat rows in Excel and automatically generate new value

[Max]

I have an Excel 2007 worksheet with a limited amount of personnel data n it.
I want to automatically generate additional rows of identical data but with a
different name (or character in the name) of the email address and/or the
last name in each successive row. The object is to take a limited amount of
data and create a larger population size in order to have more data with
which to work in a test database.

Here's a sample worksheet:


EMAIL LNAME FNAME ORG
(e-mail address removed) DOA JOHN ORG1
(e-mail address removed) DOB JOHN ORG1
(e-mail address removed) DOC JOHN ORG1
(e-mail address removed) DOD JOHN ORG1
(e-mail address removed) DOE JOHN ORG1
(e-mail address removed) DOF JOHN ORG2
(e-mail address removed) DOG JOHN ORG2
(e-mail address removed) DOH JOHN ORG2
(e-mail address removed) DOI JOHN ORG2
(e-mail address removed) DOJ JOHN ORG2

Thanks much.

 

[Sheeloo]

Enter this in A1
=CHAR(MOD(ROW(),26)+97) & "(e-mail address removed)"
and copy down

 

[Sheeloo]

You can also use
=LOOKUP(MOD(ROW(),3),{0,1,2},{"aa","bbd","ccddd"}) & "(e-mail address removed)"

You can change 3 to 4,5,6... and add corresponding strings in
{"aa","bbd","ccddd"} to have as many as you want...

 

[Max]

Thanks, Sheeloo. I'll give it a go.
Max

You can also use
=LOOKUP(MOD(ROW(),3),{0,1,2},{"aa","bbd","ccddd"}) & "(e-mail address removed)"

You can change 3 to 4,5,6... and add corresponding strings in
{"aa","bbd","ccddd"} to have as many as you want...

 

[Max]

Sheeloo, both your solutions work great! Thank you very much.

Max