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