Rearranging and Merging

[kc68]

How can I take the following:

a1 Dave Jones b1 888 Any Street Hometown, NY 11111
a2 Sally Jones b2 888 Any Street Hometown, NY 11111
a3 Joe Smith b3 899 Any Street Hometown, NY 11111
a4 Ann Smith b4 899 Any Street Hometown, NY 11111
a5 Sam Brown b5 902 Any Street Hometown, NY 11111
a6 John Evans b6 999 Any Street Hometown, NY 11111
etc.

and turn it into:

a1 Dave Jones Sally Jones b1 888 Any Street Hometown, NY 11111
a2 Joe Smith Ann Smith b2 899 Any Street Hometown, NY 11111
a3 Sam Brown b3 902 Any Street, Hometown, NY 11111
a4 John Evans b4 999 Any Street, Hometown, NY 11111

Thanks.

Ken

 

[R. Choate]

You will need a macro to do that job. Getting the address separated is easy enough but sending the wife to a new row is another
matter altogether.

--
RMC,CPA


How can I take the following:

a1 Dave Jones b1 888 Any Street Hometown, NY 11111
a2 Sally Jones b2 888 Any Street Hometown, NY 11111
a3 Joe Smith b3 899 Any Street Hometown, NY 11111
a4 Ann Smith b4 899 Any Street Hometown, NY 11111
a5 Sam Brown b5 902 Any Street Hometown, NY 11111
a6 John Evans b6 999 Any Street Hometown, NY 11111
etc.

and turn it into:

a1 Dave Jones Sally Jones b1 888 Any Street Hometown, NY 11111
a2 Joe Smith Ann Smith b2 899 Any Street Hometown, NY 11111
a3 Sam Brown b3 902 Any Street, Hometown, NY 11111
a4 John Evans b4 999 Any Street, Hometown, NY 11111

Thanks.

Ken