I am working on onboarding a new application. For the most part The entitlement collector is working, however, I believe it could be doing a better job. I am pulling data from an .csv file. The data consists of user and role. The issue I am seeing is that the roles are all aggregated together on a single row separated by a ;. When collecting the data, it take the who cell value and creates the app role like this
Here is a screenshot of the data
Is there a way to query it so the app roles are broken out individually similar to this. Changing the report is not an option from the source.
Here is my basic query: