Hello,
I have a spreadhseet that contains about 3000 rows and 2 columns. The first column is a name and the second column are their objectives from their last performance review. So the format looks like this:
Employee 1 Objective 1
Objective 2
Objective 3
Employee 2 Objective 1
Objective 2
Objective 3
The objectives were manually typed in by the employee, so there may be no rhyme or reason to having an identifier like a comma. However, when the data was exported, there were line breaks entered between the objectives. So when I export the report, I get two columns, one with the employee name and the second one with the objectives in one cell, separated by a line break. I need to take each objective and put it into a separate cell so the report will look like this:
Employee 1 Objective 1
Employee 1 Objective 2
Employee 1 Objective 3
Employee 2 Objective 1
Employee 2 Objective 2
Employee 2 Objective 3
Can anyone help on this?
Bookmarks