LinkBack URL
About LinkBacks
split comma separated names in a column to a new column
Hello,
I am working on this spreadsheet that has a list of tasks assigned to resources and schedules. Some of the tasks have multiple people assigned to them, I am trying to split the names so that they can be associated with the individual task, but if there are more that one people assigned to the task, I just want to know who else is also associated with that task.
There are 2 worksheets in the attached workbook,
Input: has the data that is exported by an application, the format will not change, the number of rows will depending on the project and tasks, the names will always be comma separated in the format, FirstName LastName, FirstName LastName. (the second set will only be there if there is more than 1 person assigned to a task)
Output: this is the report that I am trying to make it look like.
I am trying to come up with a macro that will go through the "Input" worksheet and create the "Output" worksheet.
1. Go through the names in column C and if there are more than one names present in the cell.
2. Split each name, and create a new row under it with the first name in Column (B) "Name", but also create a new column (D) "Other Resource" and put the other names in that column and do that for all the names in the column.
3. None of the information in other columns change, they are copied as is with the names associated with them.
4. Go through the worksheet and do it for all the rows that have multiple names.
If any more information is needed, please let me know. Thanks in advance, I really appreciate the help.
Register To Reply
below the post.
Bookmarks