Join and replace

[Nastya]

Hello everyone!

I have the following problem:

The target is to match two tables. In the output the second every point in route must be replaced by Hours/ Times. Every point has unique Hours/ Times only within the route (so the same point can have different Hours/ Times in different routes)

Table 1 

Route	Point	Hours/ Times
388-3256-388	388	1,5
388-3256-388	3256	2
371-388	371	4
371-388	388	5

Table 2

Route

388-3256-388

371-388

Output

Route_h/t

1,5-2-1,5

4-5

Thank you very so much for any help!

[DavidP]

There must be an easier way, but this works

[BenMoss · Accepted solution]

Here's perhaps a more simple solution that to that offered by @DavidP, but we all do things in a different way!

[DavidP]

Great solution @BenMoss. Using Concat in the Summarize tool is very neat and definitely something I'll be using all the time now! How did I not know that? This opens up so many doors...