Hello!
I have an access table filled with 10k records that look like this:
Product Car
601945 Vauxhall Astra
602117 Peugeot 806
602117 Peugeot Expert
602117 Citroen Dispatch
602227 Vauxhall Vectra B
602227 Opel Vectra B
I want it to look like this:
Product Car
601945 Vauxhall Astra
602117 Peugeot 806, Peugeot Expert, Citroen Dispatch
602227 Vauxhall Vectra B, Opel Vectra B
So putting the car models in one comma seperated column for each productcode that is the same. Now I have seen a lot of posts like this but I can't find the solution. Can you help me please?
Thanks! Sander