Using Awk to find Unique cars bought by a customer : I have log files like this :

    Customer  Car             Bought
    François  Nissan Pajero   28/05/2016
    Matthew   Mercedes S      10/01/2019
    Andrew    Peugeot 508     05/0/2000
    Matthew   Toyota Hilux    02/10/2012

I need to make an awk script which display for each customer what car he has bought like this :

    Matthew, car bought: Mercedes S,Toyota Hilux, number of cars: 2
    Francois, car bought: Nissan Pjero, number of cars: 1

I tried various things but wasnt able to do it.


