Linking a column from a new board to a pre existing template

Hi Everyone, Greeting from Sunny South Africa.
We are 3 months into using and are currently on the Standard Plan. We are willing to upgrade if it it helps us to accomplish the following issue:

We have 2 boards. Board 1 is a list of people (who are linked to a role which exists on board 2). Board 2 is a list of roles.
We want each person in Board 1 to show up in a column in Board 2 depending on which role is assigned to them on Board 1
on Board 2, our aim is to have a column that shows the names of all the people on Board 1 whom have that role assigned to them.

Are there any guru’s please?