I am looking for help where I need to bulk update some data where multiple users need to be added to a list. I have a unique vale for permissions to coalesce against to assign users to. However when doing a transform map it only actions 1 row and 1 user for each permission not if there is multiple. I suspect I may need a transform script, any advice and help with a script would be appreciated.
I have attached an example of excel sheet below. With Lookup Permissions needing to map to field name 'u_lookup' and Owner ID needing to map to 'u_user'. But need multiple owner IDs to be able to map to a single permission as per my excel example. Thanks in advance
