Organizing Large Sum Of Data into Specific Columns on the same sheet

[zjohnson]

Hello, I have a large list of organizations with 20 assigned teams - I am trying to organize them by column (team) in such a way that when I switch the team lead the organization will automatically move to the new column

[#2]

Please elaborate by attaching your sample file.