Hi all,

I am currently trying to find ways to simplify a procedure whereby I can duplicate a certain customer's details but only make 1 change to a specific field.

For example, Customer A has 5 different types of e-mail addresses. I would like the columns to appear as:

Name E-mail Address Description
ABC [email protected] blahblahblah
ABC [email protected] blahblahblah
ABC [email protected] blahblahblah
ABC [email protected] blahblahblah
ABC [email protected] blahblahblah

I have more than 20 columns to fill in, and there can be one or more column(s) that have can have this scenario appearing. Is there any way I can shorten the amount of time I need to look through each row to make sure I don't miss out on any information?

Thanks in advance!