concat values and count values for each specific id

Hello forum,

I have this long list of ID and zip code. What I need is to get for each ID the zip codes and how many in total.
On the attached file there is a sample how the result should be ...if possible. This list change often and to manually fix this is not an option...

Thanks

Try

Please Login or Register  to view this content.

That was quick , thanks it did work fine except I did not get the count values of all zip codes

Ahh, missed it.

Please Login or Register  to view this content.

Excellent!

Exactly what I needed
Humble thank you

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.