I pulled a report into excel that lists staff details and workgroups that they have access to. There are nearly 8000 staff who can have anywhere from 0 to 120 workgroups.
The workgroups are listed with the staff details in the following format:
Surname Forename Post Title 183860314040|188778743040|261226948048|584865373040|088365861041
Surname Forename Post Title 695416612049|751836367043|430463930049|461208099048|488798547045|723225723045|183860314040|472108996043
Surname Forename Post Title 177448555041|315136549047|400323457046
with the whole list appearing in one cell and not in numerical order.
I need to pull out a list for each workgroup, with all the staff who have access.
Even if there was a way I could separate out the workgroups and get them to line up.
Any help would be greatly appreciated.
Bookmarks