rstudio data column matching : I'm currently working on the project where I have about multiple CSV files need to match all combinations of events people attended by matching their customer id. They have been to multiple events. I need the events matched in a new column separated by comma. There is multiple data sets that need to be compared. Vlookup in excel was freezing due to the amount of data. How can I do this in Rstudio?  I have tidyverse already installed. Any suggestions?


     List 1   (one CSV file)                          List 2 (second CSV file)
    LastName FirstName     CustID  Event         LastName FirstName CustID Event 
    Robson     Jonson       23019   NP5          Robson   Jonson    23019   GRT2 
    Robson     Jonson       23019   RTE3

    Result Needed
    LastName  FirstName      CustID     Matched Events     
    Rob       Jonson         23019      NPS, GRT2, RTE3