Forum Discussion
Vertical Data to Horizontal Data for mail merge
If you can work with just the employee names associated with each manager, then the attached shows a way to do that. I will defer to others with more expertise if there is a simple way to get both employee number AND employee name.
This formula gets unique managers:
=SORT(UNIQUE(F2:F11))
And then this lists, horizontally, the employee names with each manager: =TRANSPOSE(FILTER($B$2:$B$11,$F$2:$F$11=J2))
If you can work with just the employee names associated with each manager, then the attached shows a way to do that. I will defer to others with more expertise if there is a simple way to get both employee number AND employee name.
This formula gets unique managers:
=SORT(UNIQUE(F2:F11))
And then this lists, horizontally, the employee names with each manager: =TRANSPOSE(FILTER($B$2:$B$11,$F$2:$F$11=J2))
mathetes thanks so much - this works really well - by pulling through the unique employee no. I can look up to the name and other info 👍
FILTER (and UNIQUE, and SORT) are all relatively new functions, and they're ones I've found to be very useful in a number of situations. I'm glad you were able to take my suggestion and improve on it for your needs.
Here's a video you might find useful in thinking of further applications. (This video is where I first learned this set of functions a year or two ago.)
https://www.youtube.com/watch?v=9I9DtFOVPIg
