Name Address Sorting

M

Murph

I have a huge list of last name, home number, street and city
My goal is to separate the info into:
Street Name
House Number Last Name

i.e.
A B C
HIGGINS 1173 Birch Bark Ct
ARBINO 1177 Birch Bark Ct
SCHLOEMER 1185 Birch Bark Ct

could appear as:

Birch Bank Ct
1173 HIGGINS
1177 ARBINO
1185 SCHLOEMER

Thoughts?
 
F

Fred Smith

Do you really need the street name on a separate line?

Why not
--sort on Column C, then B.
-- create a help column (say D) which is =B1&A1
-- hide columns A and B

Now you have everything in the order you want. If you really want the street
name suppressed on subsequent lines, create a pivot table.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top