Syncing two lists of data for one list of individuals. One list has multiple entries.

I need to consolidate these two lists of data into one list.

First set is just a basic list of individuals with their data.

Second set is multiple entries for those same individuals. Each entry shows a subscription to a programme. The final single sheet should have one row per individual which shows all of the programmes they are subscribed to.

Please see attached, example sheet.

The real list is 3000 IDs, so need some kind of formula to do this (or other suggestion?).


Any help massively appreciated.