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

M

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
[email protected] DOA JOHN ORG1
[email protected] DOB JOHN ORG1
[email protected] DOC JOHN ORG1
[email protected] DOD JOHN ORG1
[email protected] DOE JOHN ORG1
[email protected] DOF JOHN ORG2
[email protected] DOG JOHN ORG2
[email protected] DOH JOHN ORG2
[email protected] DOI JOHN ORG2
[email protected] DOJ JOHN ORG2

Thanks much.
 
S

Sheeloo

You can also use
=LOOKUP(MOD(ROW(),3),{0,1,2},{"aa","bbd","ccddd"}) & "[email protected]"

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

Max

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

Sheeloo said:
You can also use
=LOOKUP(MOD(ROW(),3),{0,1,2},{"aa","bbd","ccddd"}) & "[email protected]"

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