concat without duplicates

[Keyuser]

Hy!

I have following table:

Tour	OrderNb.
1234567	123
1234567	123
1234567	789
1234567	789
9876543	456
9876543	369
9876543	456
9876543	369

Now I want to summarize each tour on one line.

BUT concat OrderNb. without duplicates for a better view:

Like:

Tour	OrderNb.
1234567	123; 789
9876543	456; 369

Do you have any idea?

Thank you!

[atoz1158 · Accepted solution]

Hi

Try using the following

Concat(Distinct OrderNb. , '; ')

Regards

Adrian

[Keyuser]

Ouch, you're right.

Sometimes the simplest solution is the hardest 😁