Search each unique role and add it 5 times

I have an excel sheet like this

I want to be able to search each unique role and add it 5 times then go and add in another column filling it in with 3 different things. I'm not sure how to write this in code.