COUNTIF Formula to Return Multiple Values in a Single Column

Good morning all,

I made a similar request on here a few weeks ago which was very kindly solved with no issues whatsoever. Unfortunately however, I have been unable to implement the forumla again due to a third column being involved (and my profound lack of Excel knowledge ), whereas before there were only 2 columns.

I've attached an example spreadsheet to assist my explanation (which are notoriously bad) - basically the formula would lookup and match the ID number and return the 'Actions' value - which are listed as a column, sometimes several times against 1 ID - and return them across in a row.

Any help would be much appreciated guys - please let me know if you need any further info.

Many thanks,

Tom