I am looking for an excel spreadsheet (not VBA) formula to concatenate text based on variable arrays.
to clarify
I have an employeefile where employees may or may not have multiple contracts serving in different roles/capacities
i have a column with the employeenumer
i have a column with the role
I would like a third column concatenating the roles, based on the employeenember (that this happens in every employee row is not a problem)
Employee ; Role ; AllRoles
12345 ; nurse ; nurse
23454 ; nurse ; nurse,teammanager
34345 ; manager ; manager,jobcoach,teacher
23454 ; teammanager ; nurse,teammanager
56875 ; nurse ; nurse
34345 ; jobcoach ; manager,jobcoach,teacher
34345 ; teacher ; manager,jobcoach,teacher
etc
Any ideas? this cannot be in VBA in this case,
to clarify
I have an employeefile where employees may or may not have multiple contracts serving in different roles/capacities
i have a column with the employeenumer
i have a column with the role
I would like a third column concatenating the roles, based on the employeenember (that this happens in every employee row is not a problem)
Employee ; Role ; AllRoles
12345 ; nurse ; nurse
23454 ; nurse ; nurse,teammanager
34345 ; manager ; manager,jobcoach,teacher
23454 ; teammanager ; nurse,teammanager
56875 ; nurse ; nurse
34345 ; jobcoach ; manager,jobcoach,teacher
34345 ; teacher ; manager,jobcoach,teacher
etc
Any ideas? this cannot be in VBA in this case,