Consolidate road data (from and to)

Hellenicathena

New Member
Joined
Oct 2, 2014
Messages
1
I am looking for a way to automate consolidating project numbers and making descriptions match. Here is an example:

I have a very long road segment list (800+ segments) with the structure shown in the table below, which I want to consolidate into one row in a new tab with these columns: project, road, from, and to (in this example, 556, Main St, Anclote, Moog Rd).

How do I tell excel to give me the correct from and to for a project in my consolidated list? They aren't always in this order with Anclote in the top left and Moog in the bottom right.

segmentprojectroadfromto
770556Main StAnclote BlvdIrish Ave
770.1556Main StIrish AveGulf Trace
770.2556Main StGulf TraceMoog Rd

<tbody>
</tbody>








Thanks for any help or ideas! --Emily
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top