Vlookup with multiple rows of same search value
I am trying to convert an excel sheet that has multiple rows of the employee's name with one performance objective per row. So we have this:
Sue Smith/Objective 1
Sue Smith/Objective 2
Sue Smith/Objective 3
I want my Smartsheet to be like this:
Sue Smith/Objective 1/Objective 2/Objective 3
Trying to wrap my head around how to pull in the objectives from multiple rows onto my smartsheet that will have one row per employee.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!