Hey all -
I have a table with a list of managers, from Level 1-6 (each level is a new column). Therefore there is always only one manager name across 6 columns. Is there a way I can easily get all the managers into Column A?
-EN
Hey all -
I have a table with a list of managers, from Level 1-6 (each level is a new column). Therefore there is always only one manager name across 6 columns. Is there a way I can easily get all the managers into Column A?
-EN
Hello,
Assuming names are in B:G, try this formula in column A and copy down :
![]()
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks