Jinxy06
New member
- Joined
- Aug 20, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello!
I just need to be pointed in the right direction. I'm not even sure what to google to make this happen!
I'm trying to make a schedule that had times along the x-axis and positions/places on the y-axis, with the values being employees. I'd like to then have it switch the employee names to the x-axis and populate the values with the positions, This way I can easily create individual schedules for the employees.
So I want to take this:
And have excel give me this:
Is this at all possible? What am I missing? Any and all help is immensely appreciated
I just need to be pointed in the right direction. I'm not even sure what to google to make this happen!
I'm trying to make a schedule that had times along the x-axis and positions/places on the y-axis, with the values being employees. I'd like to then have it switch the employee names to the x-axis and populate the values with the positions, This way I can easily create individual schedules for the employees.
So I want to take this:
10:00am | 11:00am | 12:00pm | |
Position 1 | John | Dave | Sarah |
Position 2 | Dave | Sarah | John |
Position 3 | Sarah | John | Dave |
And have excel give me this:
10:00am | 11:00am | 12:00pm | |
John | Position 1 | Position 3 | Position 2 |
Dave | Position 2 | Position 1 | Position 3 |
Sarah | Position 3 | Position 2 | Position 1 |
Is this at all possible? What am I missing? Any and all help is immensely appreciated