I have about 180 rows of trip information I need to organize to 6 different teams. They need to be put on the team in order of time: early to late. I am having trouble figuring out the best way to go about this with my limited excel knowledge. In the attached picture, I need it to be moved to the team sections based on the value in column F. The number 1 needs the row to be moved to team 1 and so on as I'm assigning values to column F. The picture I attach shows what I'm working with and kind of how I'd need it to look. I need to assign on column F and have it move over in real time to the "Teams" so I can make sure it's a good map for the day. Any help will be appreciated.
Thank you!
Bookmarks