clean up some fields in google sheets

I have some fields that need cleaning, have all the details i one single columns from a copy and paste. some fields and repeat need to be clean up:
number of users needs to match the number of users on the first reference sheet.
need them to appear with header:
name email role
jane smith j@smith manager

is something simple, the largest sheet has 85 users.

I need this asap, so please only bid if you can do right now.