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!
Breanna_28
Offline
Last seen: 7 months 1 week ago
Joined: 10/24/2016 - 15:02
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.