I am working with spreadsheets that have four columns: app username, first name, last name, role. The same user can have multiple roles in the spreadsheet. I am trying to merge these down into one, but want to have this step completed during the import process I have coded.
By default, the table appears like:
App Username First Name Last Name Role
john.smith John Smith User
john.smith John Smith Admin
john.smith John Smith RO
What I would like it to output as is (with the 'Role' field all being one cell):
App Username First Name Last Name Role
john.smith John Smith User
Admin
RO