[allenkc]

Is it possible somehow to take a list of names in an excel file that are listed in columns per below:
Employee Dependent SSN
Bob Smith Tracy Smith 444444444
Bob Smith Terry Smith 333333333
Bob Smith Alice Smith 222222222

What I need is for the results to be like in a flat file (or all in one line)like this:
Employee Dependent1 SSN1 Dependent2 SSN2 Dependent3 SSN3
Bob Smith Tracy Smith 444444444 Terry Smith 333333333 Alice Smith 22222222

I am trying to do a mail merge and it needs to be in this order if possible. Does anyone have any idea if this is possible??? Thanks!!

[OBP]

This can be done in either Access or Excel. But I think that you will need an Excel Macro or Access VBA to do it.
It is probably marginally easier in Excel with a macro, but the control of the data is better in Access, so really the choice is yours, personally I would go with Excel if the data is already there.

[allenkc]

Thanks for your advise but there lies the main problem, I do not know how to write a macro. Could any give any advise on how to write a macro in excel (if it is the easiest)?

[OBP]

allen, I am just a bit busy at the moment, I will ask slurpee if he can have a look at it for you, he seems to be the only other regular looking in at the moment, although Double Helix might take a look.
If they can't do anything for you by tomorrow i will have a go, it shouldn't take long it just needs a loop to compare the names in Column A and if it doesn't change put the name in Column B in to the next column on another sheet.

[OBP]

It would help if you posted an excel sheet with those examples on already

[allenkc]

Here you go OBP.

One other thing, I am only showing 3 dependents on this sheet but I need to make it work for up to 8 dependents.

Thanks for your time.

[OBP]

This should do it, just click the button

[allenkc]

WOW....thank you so much. That should do it!!!

[OBP]

Can you mark the thread as Solved please?