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

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

Thanks much.

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

Enter this in A1
=CHAR(MOD(ROW(),26)+97) & "
and copy down

"Max" wrote:

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

Thanks much.

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

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

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


"Max" wrote:

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

Thanks much.

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

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

"Sheeloo" wrote:

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

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


"Max" wrote:

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

Thanks much.

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

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

Max

"Sheeloo" wrote:

Enter this in A1
=CHAR(MOD(ROW(),26)+97) & "
and copy down

"Max" wrote:

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

Thanks much.