Reorder columns from averages

I have a simple Excel table, like so: Event Name Player A Rank Player B Rank Player C Rank Player D Rank Player E Rank Dodgeball: Jan. 1 1st 4th 2nd 3rd 5th Drag Race: Feb. 3 2nd...