I have a file that adds multiple user groups for a user into one column. I am wondering if there is a way to split that cell into multiple rows so the user will show mulitple times with each individual group name. I have attached an example of what I have and what I want it to look like. Thanks!
Files:
Hi Breanna,
If your spreadsheet had been set-up with the User-Based Groups being in individual cells instead of one cell then we could have done something in IDEA. So if you had something like this:
Employee
System User
We could have then used the fill-down utility to populate the missing cells.
The only way I can think of doing this, assuming you can't get the information in a better format from the source, is to write a specific script for this scenario.