Team...
I am sorry for the huge delay made in responding to your question.

Here we go...

We build a data base of party names & property history captured from scanned images.
After a complete cycle of data processing, the data base will be kept online so that the customers can search and find the information.

We came across documents showing multiple last names such as the sample I have shown in spread sheet. I have added another sample for your understanding. Plz have a look.

When name has just 1 last name, there is no problem. But the problem arises when the name has multiple last names. Because we do not know the customer's choice of search. Customer may search the property with any of the multiple last names.

So, we have decided to build the database with all possible entries. For sample-1, we are getting 12 possible entries.
Let us say that maximum no. of last names that we can come across is 3. Here are the challenges that we are facing in coming up with all possible entries:
1. Replication/Duplication
2. Missings

In order to overcome these, we have created a standard format which I have shown in the spread sheet. But still we are finding some slip outs & over postings despite of spending valuable time. Result is...dip in quality.

So, my humble request is ....please automate the format which I have shown in spread sheet.

Team...
I do not know what is wrong way or neat way but I know there should be a way to automate this. I would be very greatful to your team if you can suggest me the smart way without using VB Script.

Anticipating your quick response...

KumarSreenivas A