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!

BenMoss

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

Solution.yxmd