Vlookup with multiple rows of same search value

Christina Riot

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.

Stefan

Hi Christina,

I think making the source right is the easier way ;-)

In Excel you may want to use the "transpose" function:

https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419F2E3-BEAB-4318-AAE5-D0F862209744

Hope this helps

Stefan