Can anyone figure out how to write a formula for the following
problem?

WORKSHEET 1:
Column A = Project Title
Column B = Role

Each project may have multiple rows if a staff member works on the
project in different roles.

WORKSHEET 2:

Concatenate role names found via conditional statement

Column A Column B

Project 1 Project Manager
Project 1 Developer
Project 2
Project 3 Business Anyalyst

I'd like to take any/all roles performed on a certain project and
concatenate them in a cell on another worksheet.