create a string of results from column A that have specific value in column b

I want to create a string of values to put in a field on sheet2 using data from sheet1. The data needs to be all usernames that are administrators.
example

Usernames	Roles
Bob	Administrator
James	User
Todd	Administrator
Steve	User

this should return "Bob, Steve" to a field on sheet2